Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking for a way to insert rows underneath a row, with a macro reading
a cell, and then inserting that number of rows underneath. e.g. A column reads 500-505. The macro will seperate the numbers (500,505) into adjecent cells, calculate the difference (5), and then insert that number of columns underneath the original row (reading "500-505" with 5 blank rows underneath). I figured out how to do the calculation, but I can't find a way to insert the columns. Is there a way to do this? I already know the answer is "yes", but is it feasable for a beginner macro'er to try and implement? Thanks, Sean H |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert "Find dialog box" edits into macro | Excel Discussion (Misc queries) | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |