Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In this recorded macro, I go to Cell A1001, select it, drag the fill
handle to the cell below. Q: How can I edit the macro to select the active cell and go down one row, instead of the exact cell values in the brackets after Range? (newbie question) Is there a syntax similar to: Range(Activecell).Select Then Range("Activecell:ActiveCell+1) ??? --- recorded macro --- Application.Goto Reference:="R1001C1" ActiveWindow.SmallScroll Down:=3 Range("A1001").Select Selection.AutoFill Destination:=Range("A1001:A1002"), Type:=xlFillDefault Range("A1001:A1002").Select --- end of recorded macro --- thanks in advance PUBA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
Replacing Input Box in Macro with Info Picked Up from Active Cell? | Excel Discussion (Misc queries) | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
Replacing value in cell with answer of same cell | Excel Worksheet Functions | |||
I need to sort an active sheet using the col of the active cell | Excel Programming |