Range from highlighted area

  • Thread starter Thread starter noyb
  • Start date Start date
N

noyb

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)
 
Back
Top