0

Silly question: how do I go to the cell right after the last non-blank cell in column ? I can't figure it out for the life of me.

I've tried something akin to: Range("A2", Range("A2").End(xlDown) + 1).Activate (A1 is blank) and Range("A2", Range("A2").End(xlDown + 1)).Activate , but it errors out.

Thanks in advance!

CCM
  • 136
  • 2
  • 4
  • 17

1 Answers1

0

Use:

ActiveSheet.Cells(ActiveSheet.Rows.Count,1).End(xlup).Offset(1).Activate

NOTE: One should avoid .Activate and .Select These slow down code, but should directly use the reference.

See HERE for more information.

Scott Craner
  • 148,073
  • 10
  • 49
  • 81