Find first blank cell
Try this
Cells(3, Columns.Count).End(xlToLeft).Offset(0, 1).Select
FWIW, my grandfather was a Tibbetts.
--
HTH,
Barb Reinhardt
"Jim Tibbetts" wrote:
Cell A3 has data in it. How do I go to the first empty cell to the right so I
can paste data? I have this code and it works if there is data in cell B3,
but doesn't work if B3 is blank.
Range("A3").End(xlToRight).Offset(0, 1).Select
Thanks for any help,
--
Jim T
|