View Single Post
  #9  
Old 01-08-2006, 12:08 PM
pinmaster pinmaster is offline
Banned User!
 
Join Date: 17 Feb 2004
Location: Canada
Posts: 517
pinmaster is becoming part of the community
I'm not very good with VBA but I use something like this:

Range("B26").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True


Hope this helps!
JG
Reply With Quote