I'm struggling with one of my macros and I'm looking for some insight. There a hidden worksheet within my workbook that houses all the raw data that pulls onto my main summary page. If there's an error on my hidden "feeder" page, I want to display a message box that will inform the user that an error has occured in whatever column the error is located in. I was thinking about creating a line of code for each column that says if there's an error anywhere in this column, then display this message "(message here)", otherwise display nothing.
I don't know how to use VBA to identify errors and then do something, so any help would be appreciated. I guess what I'm trying to do is similar to the iferror function, only I want to use VBA to display a specific message box. Thank you in advance for everyone's time.