I want to work with a range; the location, size etc., is defined by the
user highlighting an area on the worksheet then starting up a macro. How
do I use the currently highlighted area as a range?
Thanks

Use the Selection object. E.g.:

Selection.Interior.ColorIndex = 6

In article , noyb
wrote:

I want to work with a range; the location, size etc., is defined by the
user highlighting an area on the worksheet then starting up a macro. How
do I use the currently highlighted area as a range?
Thanks

This highlighted area is called the selected range, and can be accessed in
VBA with the Selection object.

Selection.Address

returns the address of that selection,

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"noyb" wrote in message
...
I want to work with a range; the location, size etc., is defined by the
user highlighting an area on the worksheet then starting up a macro. How
do I use the currently highlighted area as a range?
Thanks

Selection

as in

msgbox Selection.Address

--
Regards,
Tom Ogilvy

"noyb" wrote in message
...
I want to work with a range; the location, size etc., is defined by the
user highlighting an area on the worksheet then starting up a macro. How
do I use the currently highlighted area as a range?
Thanks