MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Assign contents of active cell to a variable

Posted by Troy Buzzard on December 08, 2000 7:58 AM

I would like to reference the current position of the cell pointer within a macro so that I can assign data in the active cell to a variable. Example....Variable = Range("A1").Value....except the range will not remain constant. Thank you.

Posted by greg on December 09, 2000 9:19 PM

response: Variable = activecell

Posted by greg on December 09, 2000 9:22 PM

response: Variable = Activecell