For some reason my code is not working properly. No matter what number is in the cell the Msgbox comes up. I believe that the program is not recognizing the number 1. How does vba recognize it's a number rather than just a string?
I tried to change the cell the number, but that didn't do the trick.
Please Login or Register to view this content.
Hi, Templemind,
maybe you missed a dot before Cells
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
May be this...?
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you HaHoBe, that worked. How simple was that too.
Sixthsense, I tried his suggestion first. Yours did not seem to work for me. Thank you though
Hi, Templemind,
for an explanation: without using the dot in front of cells this refers to the active sheet not the sheet you used Application.Match on. So an empty cell on the activesheet will always create the message while proper use of With-Statement won´t.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks