I'm trying to extract the value (both text strings and numbers) from a cell and put it into another cell without creating a reference.

The cell I am extracting from I will want to change, but I want the value in the new cell to stay the same when I change the first...

The reason for this is to record a Macro to populate a row with values from a column. It works fine, but when i run the macro (with relative references) the values taken from the first row also change....

any ideas? basically just need to take the contents of the cell...

Thanks in advance