Thanks for sharing your "Excell Smarts"

The problem is:

From a user selected cell, I need to copy the line, and paste it in a
specified cell, modify the line, and return to the cell that was first
selected, and paste the new "altered" line where it was when I started.
Excell needs to remember where I first selected the cell cause this is
quite a large spreadsheet. Is there a way to store and retrieve a cell
address to use with the copy and delete functions. Oh, this is all in
Visual Basic programed macros.

I just have to keep remembering that all who wander are not lost.

Thanks...
"The wander"


--
spydor
------------------------------------------------------------------------
spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438
View this thread: http://www.excelforum.com/showthread...hreadid=496842