Thread: a simple macro?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
asalerno
 
Posts: n/a
Default a simple macro?


I have been trying to write what I thought was a simple macro with no
luck.

I have a column of text and I want to insert 2 blank lines between
every cell of text.

Example of what I have:

excel
excel
excel

What I want:

excel

excel

excel


I have been able to get the macro to insert 2 blank cells for however
many times I want, but I cannot get the macro to move down 3 rows
before it inserts the next 2 blank cells.

I have tried using xldirection and offset commands with no luck. This
is my first time playing with macros so it's quite possible I'm not
even using the above comands correctly. Anyone have an idea?


--
asalerno
------------------------------------------------------------------------
asalerno's Profile: http://www.excelforum.com/member.php...o&userid=33927
View this thread: http://www.excelforum.com/showthread...hreadid=537047