| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Determining a call in a macro
Excell 2003
If lastreading limit And NLastreading limit Then AlrtMsg = (LineId & " Water Excursion(2) " & Hr2 & ":55 over by " & lastreading - limit & " gal.") Call WaterAlrt(LineId, AlrtMsg) End If How can I determine where WaterAlrt is located? Part of this macro is sending a call to it but I need to locate exactly where it is at to edit it. |
|
#2
|
|||
|
|||
|
-- HTH RP (remove nothere from the email address if mailing direct) "Mark" wrote in message ... Excell 2003 If lastreading limit And NLastreading limit Then AlrtMsg = (LineId & " Water Excursion(2) " & Hr2 & ":55 over by " & lastreading - limit & " gal.") Call WaterAlrt(LineId, AlrtMsg) End If How can I determine where WaterAlrt is located? Part of this macro is sending a call to it but I need to locate exactly where it is at to edit it. |
|
#3
|
|||
|
|||
|
Do a Find, with the current project button selected.
-- HTH RP (remove nothere from the email address if mailing direct) "Mark" wrote in message ... Excell 2003 If lastreading limit And NLastreading limit Then AlrtMsg = (LineId & " Water Excursion(2) " & Hr2 & ":55 over by " & lastreading - limit & " gal.") Call WaterAlrt(LineId, AlrtMsg) End If How can I determine where WaterAlrt is located? Part of this macro is sending a call to it but I need to locate exactly where it is at to edit it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Button fails to call macro when open an Excel via Intranet | Excel Discussion (Misc queries) | |||
| How to call a macro in an XLA add-in | Excel Discussion (Misc queries) | |||
| .ONACTION macro call fails | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Date macro | Excel Discussion (Misc queries) | |||
Linear Mode
