Thread: Macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Macros

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.
--
sb
"Valerie" wrote in message
...
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!