Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple macro help | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Simple macro please | New Users to Excel | |||
Recording simple macro | Excel Worksheet Functions | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |