tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
So I need a macro that when run does this
Looks at the sheet("Raw") and checks if any cells contain the word "Empty"
now this will be the only word in the cell so we should check entire contents.
if it finds anything,
msgbox "You meed to deal with Empty's"
if not do nothing
thanks
Tony
So I need a macro that when run does this
Looks at the sheet("Raw") and checks if any cells contain the word "Empty"
now this will be the only word in the cell so we should check entire contents.
if it finds anything,
msgbox "You meed to deal with Empty's"
if not do nothing
thanks
Tony