Thread: Help with filling empty cells with string + row()
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_652_] Leith Ross[_652_] is offline
external usenet poster
  
Posts: 1
Default Help with filling empty cells with string + row()

Hello John,

Replace this line of code...
activecell.offset(1,0).select


With...

With ActiveCell
..Offset(1, 0).Value = .Text & .Row
End With

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=561330

Reply With QuoteReply With Quote