Determining a call in a macro

[Guest]

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)

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)

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.