ExcelBanter - Saving the activecell range for later use

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Saving the activecell range for later use (https://www.excelbanter.com/excel-programming/318816-saving-activecell-range-later-use.html)

Tim Coddington

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?

All times are GMT +1. The time now is 10:13 PM.