Saving the activecell range for later use

[Tim Coddington]

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?

 

[KL]

Dim LastCell As Range
Set LastCell =ActiveCell

Regards,
KL

 

[Tim Coddington]

SET SET SET! Yea Ok Thanks!

Dim LastCell As Range
Set LastCell =ActiveCell

Regards,
KL