Pasting the actual text of a cell

Is there a way to paste the actual text of a cell (e.g. IF statement, calculation of some fields) not the formulas or values without adding the $?

I’m using Office 2002

Thanks

Are you doing this programmatically (VBA)?

I don't quite understand the question. Are you saying that if cell A1 has the contents "Hello", you want to copy "Hello" to a different cell?

A1 =Sheet1!C128
A2 =Sheet1!C129

When I copy row A and B into row 10 and 11 it will get a mapping of
A10 =Sheet1!C138
A11 =Sheet1!C139

I want it to stay
A10 =Sheet1!C128
A11 =Sheet1!C129

Thanks

I just updated my reply.

As far as I know you would need to use the $ to reference a static location for copy and past of a group of cells. Now if you want to copy the cells one by one you can select the cell to copy from and copy the text in the formula bar and then past this into the new cell and the reference will not change.