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
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