Where am I?

  • Thread starter Thread starter David Smith
  • Start date Start date
D

David Smith

Hi there - I used to know a way of determining which cell I was in - for
instance, to know what cell I was in when a macro is run. And through age
I've forgotten.

Can anyone help please?

Cheers

David Smith
 
David,

The ActiveCell object will return a reference to the active cell.
The Selection object will return a reference to all cells that are
selected.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top