Thread: Macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valerie[_3_] Valerie[_3_] is offline
external usenet poster
 
Posts: 3
Default Macros

I am trying to make a macro that enters a specific price
(ie: $50.00) and after this to have the next selected

cell
be the next empty cell down at the beginning of the row.
Right now when I make the macro the cursor always

returns
to the specific cell it went to before (ie: B4). I

don't
understand why it returns to that specific cell b/c it's
not set up as an absolute cell reference.

Help!


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.
--

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.