Changing Cell Range in a Macro


Posted by Daniel Engel on March 27, 2001 8:02 AM

Is there a way to set the cell range in a macro to whatever cell(s) are currently highlighted?



Posted by mseyf on March 27, 2001 10:00 AM

not clear on your question, but I think you might be looking for:

Set RangeName = Selection

RangeName being the reference to the highlighted cells

HTH

Mark