Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I'm trying to create a macro that but it keeps returning to the same cell.
How can I change it to run from whatever cell I'm in? Sub Medford() ' ' Medford Macro ' Macro recorded 1/3/2009 by ted ' ' Keyboard Shortcut: Ctrl+m ' ActiveCell.FormulaR1C1 = "Medford" Range("C4").Select ActiveCell.FormulaR1C1 = "250" Range("B4").Select Selection.EntireRow.Insert End Sub Sub Porland() ' ' Portland Macro ' Macro recorded 1/3/2009 by ted ' ' Keyboard Shortcut: Ctrl+p ' ActiveCell.FormulaR1C1 = "Portland" Range("C4").Select ActiveCell.FormulaR1C1 = "54" Range("B4").Select Selection.EntireRow.Insert End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Writing a macro | Excel Worksheet Functions | |||
Writing macro in Excel | Excel Worksheet Functions | |||
Writing Excel Macro | Excel Worksheet Functions | |||
Writing a Macro to add decimal | Excel Worksheet Functions | |||
writing macro | New Users to Excel |