View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ted[_3_] Ted[_3_] is offline
external usenet poster
 
Posts: 1
Default Writing Data with a macro???

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