ExcelBanter - Determining a call in a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Determining a call in a macro (https://www.excelbanter.com/excel-discussion-misc-queries/23687-determining-call-macro.html)

Mark

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.

Bob Phillips

--

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.

Bob Phillips

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.

All times are GMT +1. The time now is 07:35 PM.