Thread: Saving the activecell range for later use
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Coddington Tim Coddington is offline
external usenet poster
  
Posts: 94
Default Saving the activecell range for later use
Ok. Everyone probably knows this one but me. I seem to not be getting my
object typing correct.

Seems like you should be able to go ...
Dim LastCell As Excel.Range
LastCell = ActiveCell.Range("A1")

And then use LastCell in a With like With Activecell.

What types should I be using to do this? Where am I going wrong?


Reply With QuoteReply With Quote