Macros

  • Thread starter Thread starter Valerie
  • Start date Start date
V

Valerie

I am trying to make a macro that enters a specific price
Valerie,

Post a copy of your macro and be a little more specific in your description:
which cell gets the $50.00 and which cell you want to go to.
example: C4 gets $50.00 goto A5
C5 gets $50.00 goto A6
Sounds like you have Range("B4").Select in your code.
--
Click to expand...
Steve,
You are correct with your example. Here is a copy of the
macro I end up with.

Sub Macro1()
'
' Macro1 Macro
' Und Inspect Fee $24.50
'
' Keyboard Shortcut: Ctrl+j
'
ActiveCell.FormulaR1C1 = "24.5"
Range("B4").Select
End Sub

Thanks for any help.
 
like this?

Option Explicit

Sub Macro1()
'
' Macro1 Macro
' Und Inspect Fee $24.50
'
' Keyboard Shortcut: Ctrl+j
'
ActiveCell.FormulaR1C1 = "24.5"
Cells(ActiveCell.Row + 1, 1).Select
End Sub
 
Back
Top