I have a button used to email a sheet. What I would like to do is when someone presses the email button, Sheet2 is checked J8:L24 for data and if each cell in that range is not filled in, present a stop message to the user.
Thank you!
I have a button used to email a sheet. What I would like to do is when someone presses the email button, Sheet2 is checked J8:L24 for data and if each cell in that range is not filled in, present a stop message to the user.
Thank you!
If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!
Perhaps this.
Please Login or Register to view this content.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
I receive the message even if all the fields are filled in. I tried to change worksheets to sheets.. but that didn't work as well.
What I am confused about is if I make it check 1 cell it works fine.
Ok, so now it works and I didn't change anything about that 1 cell. When I added back all the cells... .it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks