I have a code that searches in a column for a value and deletes three lines if the value matches. And the code will continue based on the last value in another column. I switched up a few parameters in the code and now it's breaking. Can someone help explain why?
Please Login or Register to view this content.
Works fine for me.
I would use .End(xlUp) instead of .End(3)
Entia non sunt multiplicanda sine necessitate
It works fine with me too.
You didn't the specify the worksheet so I'm assuming that you run your code on the activesheet.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Well every so often in all my data there is a footer that will have "Continued" in it. So I'm looking for that value and then deleting that row and the next two rows in addition. The code works fine for me when it was looking for continued in column G:Originally Posted by shg
But When I changed it to look for "Continued" in column F it breaks right here:Please Login or Register to view this content.
Please Login or Register to view this content.
What does "breaks" mean?
I get a Run-time error '13': Type mismatch
What was in the cell?
NVM that. Post a workbook that illustrates the problem.
Does it break with this modification?
Please Login or Register to view this content.
No it breaks with this modification:
It works fine in column G, but not when I change it to column F.Please Login or Register to view this content.
Can you attach a sample file which produces the error? Myself I can only guess at this point, but I think I may see something which would cause it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks