Find Call procedure code within module list

[ipbr21054]

I wish to find where the code is for Call procedures.

For these Example.

@RoryA I did look through some old posts but didnt find what you advised.
Something like but isnt Shift Control F5 etc etc,please advise again & this time i will make a note of it Thanks

Private Sub UserForm_Initialize()
Application.ScreenUpdating = False
On Error GoTo End_here
Call add_val("LOST")
Call add_val("DELIVERED NO SIG")
Call add_val("RETURNED")
Call add_val("UNKNOWN")
End_here: Application.ScreenUpdating = True
End Sub

 

[ipbr21054]

That is correct.
Column G from Row A2183 to last row with values in.

Still confused as you wrote "it seems badly coded to me as it searches 7 columns but uses a fixed offset to return data from that found row"

Shall i start a new post with how to write this properly / better

 

[RoryA]

It's not just looking at column G though. It is looking in all the cells from A2183 down to the last row in column G, not just the cells in column G in those rows. So if the last data row is 4000, it's looking at every cell in A2183:G4000, not just G2183:G4000. You probably just need to alter the A2183 to G2183.

 

[ipbr21054]

Ah ok so that was my mistake.
Makes sense now & as im interested in a valow that is only in column G not sure why i had it as A2183
Now changed to G2183

Thanks very much