Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |