Copy value in column a

[watchouse]

Hi,

This is a bit tricky to explain but here goes...

I have a macro that copies the value on the current cells, then goes to a form type sheet and pastes it so that the contents of the form are calculated using vlookup. The only thing is that the current cell has to be the the cell I want to copy.

What I need is some code that copies the content of the first column (column A) regardless of which is the the current cell on that row.

Thanks,
Andy

 

[ZoNe747]

Hi Andy would this help?



Range("C2").Select
Selection.Copy
Range("C2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

 

[watchouse]

Not really as the row changes!