Hi Guys,
I'm trying to make an efficient number checking macro that looks for the number 250 in certain cells/columns and if it exists to throw a popup.
Sheet 1:
Sheet 2:![]()
Range("D2:J" & LastRow) Range("L2:M" & LastRow)
LastRow is defined by Column A![]()
Range("E15:P" & LastRow)
Filters? For loops? Arrays? or Search/Find?
I'd greatly appreciate some snippets of code to do this in the most efficient way.
Bookmarks