66tigger40
Technical User
Hi
I have a spreadsheet that I have the following code running:
Do Until IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop
End Sub
Which works fine but I need it to select all the cells until it reaches an Empty cell - I'm sure it's really simple but i can't figure it out today
Thanks in advance
N
I have a spreadsheet that I have the following code running:
Do Until IsEmpty(ActiveCell)
ActiveCell.Offset(1, 0).Select
Loop
End Sub
Which works fine but I need it to select all the cells until it reaches an Empty cell - I'm sure it's really simple but i can't figure it out today
Thanks in advance
N