| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cant run insert row through loop
Anyone know why the following code wont run through a loop without an error
The "Selection.insert" wont insert a row the second time.............it will do it the first time through a loop then when the value "Current_Row" increases it bombs I also tried "Rows(Current_Row).insert" with the same results Current row is dimensioned as an integer Current_Row = Range(Range(ActiveCell.Address).Address).Row ActiveCell.Offset(1, 0).Select Next_Address = ActiveCell.Address Rows(Current_Row).Select Selection.Insert Shift:=xlDown -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find loop doesn't loop | Excel Discussion (Misc queries) | |||
| Insert Variable Number of Rows; With Loop | Excel Worksheet Functions | |||
| Worksheet_Change - loop within a loop | Excel Programming | |||
| help on insert rows and fill down loop until end | Excel Programming | |||
| HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Threaded Mode
