Cells(Selection.Row, 1).Value = ????


On Sat, 6 Nov 2004 14:33:03 -0800, Buzzsg
wrote:

I'm trying to write a macro that looks at the current cell location in order
to move the data into col A.
I used the macro record feature and then tried to edit the result into a
macro that can be used from any cell location.
The macro line: Range("A" & Text(Row(), "##")).Select.ActiveSheet.Paste
does not work because Text(Row(), "##") is not compilable BUT it works on
the spreadsheet.

"Mcasteel" wrote:


Im not sure If I understand the question...


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile:
http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=275930