Hi,
Anyone got an idea how to overcome this problem.
if looping through a range, one of the cells has #N/A it causes a "Run Time Error 13 Type Mismatch error
usually the range will have numbers in them.
How do i get the loop to go to next cell?
Please Login or Register to view this content.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
I reckon countif would be more efficient than looping thoughPlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
You can include an error trapping
On error resume next
Or you could inlcude one of thes line in your code.
Please Login or Register to view this content.
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Thanks all.
That done the trick.
Had amoment of blindness then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks