Macro to check values based on certain text

[Howardc]

Thanks for the help, much appreciated

[Howardc]

Hi Admin

I picked up that if the first value in say column B in line with the text "check" is negative, the row number is not displayed. However, if postive the row number is displayed. It would be appreciated if you could amend the code to incorporate this