Thread: Splitting Cell content into separate Rows
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ikaabod[_71_] Ikaabod[_71_] is offline
external usenet poster
  
Posts: 1
Default Splitting Cell content into separate Rows

There is one thing that needs changed actually. Change:
ActiveCell.Offset(-r2, -2).Activate
to
If ActiveCell.Column < 1 Then ActiveCell.Offset(-r2, -2).Activate


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=542520

Reply With QuoteReply With Quote