hi
I have a loop that check the following :
the cells in D has a formula :
Please Login or Register to view this content.
the formula works perfect, the cell is not formatted (general)Please Login or Register to view this content.
on a time that a DEBLOCK appear in a cell and the loop detects it, I get a debug window on the "IF" line
Type mismatched error 13, and I see in watch window error 2042 variant/error
anyone understand this ???
Thanks
Chris
Last edited by incobart; 05-31-2018 at 08:35 PM.
Can you create the issue in a sheet and upload it?
use the go advanced button just below and to the right of the quick reply box.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Are you sure there isn't an error value in the cell when the code breaks?
Don
Please remember to mark your thread 'Solved' when appropriate.
hi, it looks not, I changed the formula from "DEBLOCK" to 0 and he went on,
I saw that he already did a few time deblock before with no problem, so I put it back ans wait now if this was an exceptional occasion or not
ok xlnitwit, you n were right !
the cell where Deblock was, was ok, but in the column he had to check there was a #N/A
I put if isna, "", in front.. problem solved
thanks for suggestion
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks