I have a simple VBA code that functions fine provided there are not any symbols in any of the cells. When there are symbols, I get the mismatch error. I have included "On error resume next" in my loop; however, the previous value is output into a cell instead of leaving it blank. How do I adjust my code so that when there is a symbol in an input cell, the output cell remains blank instead of just having the previous value placed?
Please Login or Register to view this content.
You should first check that cell holds numeric value.
Ex:
Alternately you can use Application.Count() for checking.Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
@CK76,
I think you will need to add the .Value property to the test otherwise Range will be returned rather than the typename for the contents.
Please Login or Register to view this content.
Let the formula do the job.
Please Login or Register to view this content.
Andy thanks for catching that one forgot to add it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks