Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to have a macro repeat a specified number of times? For
example, I have a spreadsheet that comes from my accounting software that has about 30,000 lines. Only the first, fourth, seventh etc line is needed. From the beginning, I need to move down a row, delete two rows, move down a row, delete two rows until the entire data is cleaned up. I can record the macro to delete the two lines, but I don't know how to make it repeat. Ideas? Thanks, Dino |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repeating a Macro For Each Selected Worksheet | Excel Worksheet Functions | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro to eliminate repeating account numbers | New Users to Excel | |||
help with macro to save repeating data entry | Excel Discussion (Misc queries) |