| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert # of Rows determined by cell
Hey Dave, Thanks for the help.
I copied the code you gave and changed the ("sheet1") to my sheet and I assume that was all I had to change. You were correct that I do have headers in Row 1 so I left FirstRow=2. Everything else looked right, but when I compiled the code it highlighted the 3rd to last line. ..Rows(iRow +1).Resize(HowMany).Insert HowMany I haven't used most of the code before, is this just a () or something else? Thanks Again! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find DMIN in a column range determined by a number in another cell | Excel Worksheet Functions | |||
| How do I restrict cell entries that are determined by a previous l | Excel Discussion (Misc queries) | |||
| how do i insert rows in a cell | Excel Worksheet Functions | |||
| Getting a value from a cell that is determined by a formula | Excel Discussion (Misc queries) | |||
| How do I generate a sum, determined by cell color? | Excel Worksheet Functions | |||
Threaded Mode
