Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert 2 formatted rows at cursor location
It must be Friday. Drawing blank!?
Trying to set up code so that where-ever my cursor is positioned, I can insert 2 formatted rows. Since the rows can be required "anywhere", the formatting needs to reflect the row positioning of the new lines. If someone would kindly help me get started................... What I have now is: Rows("65522:65523").Select Selection.Insert Shift:=xlDown Range("A65522").Select ActiveCell.FormulaR1C1 = "^^" Range("A65523").Select ActiveCell.FormulaR1C1 = "^^" etc.............................. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine cursor location? | Excel Discussion (Misc queries) | |||
Tracking cursor location | Excel Worksheet Functions | |||
Function for cursor location | Excel Worksheet Functions | |||
Cursor Location | Excel Discussion (Misc queries) | |||
Cursor Location | Excel Programming |