Hi,
I have a problem concerning datatypes for an if-loop, the failure message tells me "Datatypes incompatible" for this code-line:
Here is also the full context:
Please Login or Register to view this content.
Thanks in advance for your help!Please Login or Register to view this content.
Last edited by RoyMakaay1985; 09-09-2009 at 09:53 AM.
If you use "R" & last you need to use Range rather than Cells
This will still fail if the contents of column R is empty or not a number.
Also unless you have a named range "Last" you need to remove the quotes from the Copy statement. And from the calculation of 3+i
Please Login or Register to view this content.
Hi Roy
Try changing this line
Please Login or Register to view this content.
Still yields the same error message, tried both your changes.
But as I mentioned in my first post, the error message shows up in the code-line with "if"... So CW and the cell entry from "R" & last do not match. However, I formatted the Cell to be a number.
I think you need
Please Login or Register to view this content.
Last edited by pike; 09-08-2009 at 04:35 AM. Reason: add code i = i + 1
Ok, that helped. Now the copying works.
However, only the last line in the file (Line 5000) is copied, even though (5000,18) is empty. The method is only supposed to check column R, if there is an entry. Does XX >= (number) yield true, when XX is empty?
Hey Roy
Try changing
Please Login or Register to view this content.
or even
remenbering the column and row positions are reversed when using cells ; 18 is column R
Please Login or Register to view this content.
Aha, that makes sense. I changed it to
so that the whole row is copied to the other sheet.Please Login or Register to view this content.
Now everything works fine, except for that if the entry in "R" & u is empty, the row still gets copied... Why is that?
Roy
try..
Please Login or Register to view this content.
Now it yields "Datatypes incompatible" again, when the if-loop starts to find empty cells
just had to have a cuppa..
I would write script as
Please Login or Register to view this content.
Hey Roy
the error in your code is Week in the inputbox needs to be "Week"
Dude if the code works can you please mark the post solved
Sorry, didnt know about tis function. HJow do I mark it?
Thanks for your help!
Actually, I have one additional problem... I tried the same routine, but this time, I am looking for entries "X" and "x". The column is formatted as text, but again, the error message yields "Datatypes incompatible" Here's the code:
Thanks again for help!Please Login or Register to view this content.
Hi Roy
just have to repeat statment for the or
to mark solved go back to your first post and editPlease Login or Register to view this content.
then go advanced and change the prefix
Thanks a lot once again, it works
No thank you for marking the post solved
Besides you had all the right code it just need a fine tune
well done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks