Thread: How do I return the location (as a range) of ActiveCell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default How do I return the location (as a range) of ActiveCell?
?
ma=activecell.address

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Caeres" wrote in message
...
I need the reference to a range to be dynamic, based on the ActiveCell.
How
can I return the range of the ActiveCell so that I can use it in
operations
requiring a Range as an argument?

Reply With QuoteReply With Quote