Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert New Row on Sheet Not in Focus
Is there a code that I can assign to a command button located in sheet
1 that inserts a new row in sheet 3-without activating sheet 3 (putting it in focus)?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert New Row on Sheet Not in Focus
Hi Bull:
worksheets("sheet 3").rows(insert row number here).insert or worksheets("sheet 3").range("C5").entirerow.insert -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Bull" wrote: Is there a code that I can assign to a command button located in sheet 1 that inserts a new row in sheet 3-without activating sheet 3 (putting it in focus)?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Advanced Filter w/o having to set focus on the sheet | Excel Programming | |||
HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
Giving focus to a particular sheet | Excel Programming | |||
Focus sheet | Excel Programming | |||
Adding a new sheet (no focus) | Excel Programming |