Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a step by step procedure on macros?
I have a amcro and cannot get it to run, I have come to the conclusion that I
must be doing something basic wrong. Our company tech. support cannot see anything wrong, so it must be something overlooked. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a step by step procedure on macros?
Bill,
Can you post your macro? "Bill" wrote: I have a amcro and cannot get it to run, I have come to the conclusion that I must be doing something basic wrong. Our company tech. support cannot see anything wrong, so it must be something overlooked. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a step by step procedure on macros?
Go into the VBE and click inside the procedure.
Hit F8 to step through the code. If this doesn't help, you may want to post the code (like Toppers suggested) and post more details--where is the code located, how you start the macro. And make sure you've enabled macros when you opened the workbook. Bill wrote: I have a amcro and cannot get it to run, I have come to the conclusion that I must be doing something basic wrong. Our company tech. support cannot see anything wrong, so it must be something overlooked. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a step by step procedure on macros?
This is the macro and it is in the this workbook module
Private Sub Worksheet_Change(ByVal Target As Range) If Target(1, 1).Address = "$C$5" Then With Worksheets("LogSheet") .Cells(.Rows.Count, 1).End(xlUp)(2, 1).Value = Target(1, 1).Value End With End If End Sub "Dave Peterson" wrote: Go into the VBE and click inside the procedure. Hit F8 to step through the code. If this doesn't help, you may want to post the code (like Toppers suggested) and post more details--where is the code located, how you start the macro. And make sure you've enabled macros when you opened the workbook. Bill wrote: I have a amcro and cannot get it to run, I have come to the conclusion that I must be doing something basic wrong. Our company tech. support cannot see anything wrong, so it must be something overlooked. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a step by step procedure on macros?
The Worksheet_Change event doesn't belong in the ThisWorkbook module.
Worksheet_Change belongs behind the worksheet that's getting the change. There is a Workbook_SheetChange event, though. (But I bet you're looking at one sheet. So I bet this doesn't apply in your case.) Bill wrote: This is the macro and it is in the this workbook module Private Sub Worksheet_Change(ByVal Target As Range) If Target(1, 1).Address = "$C$5" Then With Worksheets("LogSheet") .Cells(.Rows.Count, 1).End(xlUp)(2, 1).Value = Target(1, 1).Value End With End If End Sub "Dave Peterson" wrote: Go into the VBE and click inside the procedure. Hit F8 to step through the code. If this doesn't help, you may want to post the code (like Toppers suggested) and post more details--where is the code located, how you start the macro. And make sure you've enabled macros when you opened the workbook. Bill wrote: I have a amcro and cannot get it to run, I have come to the conclusion that I must be doing something basic wrong. Our company tech. support cannot see anything wrong, so it must be something overlooked. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need step by step instructions to try, not a demo. Can't remember | Excel Worksheet Functions | |||
Need step by step instructions to try, not a demo. Can't remember | Excel Worksheet Functions | |||
can't install CD from Excel 2003 step by step | New Users to Excel | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |