Dim Dynamic Cell Address

Hi --

I believe/hope this is a simple ask.

I want to set a cell address as a variable, lets call it 'xxCell'. I'm hoping to loop my code so that right before the loop, it activates 'xxCell' then offsets by 1, then defines the new active cell as 'xxCell' and so on/so forth (there will code running between each new defintion of 'xxCell').

I'm good on the offsetting and defining. I'm just having trouble being able to return to a cell that has been defined as the 'xxCell' cell

I hope that was clear enough

Thanks!

Originally Posted by ImranBhatti

Do you mean something like this?

Please Login or Register  to view this content.

this works!!

for posterity, this simplified version is what i was looking for:

Dim xxCell As Range
Range("A1").Activate
Set xxCell = Selection

Thanks!