Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a macro to insert a set number of rows, scroll the mouse, hit the
hotkey again and rows are inserted there. Specifically: I want to put the cursor on a row and have two new rows (blank) inserted beneath the row I have the mouse on. Just scroll the mouse to a row, click a hotkey, two new rows are inserted, scroll the mouse to a new location, hit the hotkey, two new rows inserted there--and so forth. I've tried; but my macro, every time I hit the hotkey, keeps adding row to the initial location. It is using absolute address instead of relative & I don't know how to get it to stop (if that's what needs to be done.) The macro I made was --start it recording, choose a hotkey, select a row beneath where I wanted the first new rows to appear, select the row below that, go to "Insert" on the toolbar select row stop Macro recording. --no matter where I put the cursor, the news rows are added to the original place that I selected the rows to go. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to Unhide Rows using Macro | Excel Worksheet Functions | |||
Step up blank rows | Excel Discussion (Misc queries) | |||
Macro Help Needed: Comparing cell values and deleting rows | Excel Discussion (Misc queries) | |||
Macro Help - Indefinite Rows | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) |