Error msgs: "Object varible or with block variable not set"; "subscript out of range"

[menyanthe]

The following macro gives me two types of error messages:
"object variable or with block variable not set" or "subscript out of range" on the first or the second line valFoundRow=...
And I could not understand why...
What I am trying to do is delete a couple of rows with unnecessary information, then copy the rest in different columns, not in one as they are now. I have no problem with the second part of the macro - it worked just fine before I added the part where the rows, containing "Share", "Save", "Email a Friend", "TRUE and the empty rows are supposed to be deleted.

If anyone could help me with that, I would be really grateful...

Please Login or Register  to view this content.

[shg]

Welcome to the forum.

Plese take a few minutes to read the forum rules, and then edit your post to use CODE tags instead of QUOTE tags, and amend your thread title.

Thanks.

[menyanthe]

Hi, I have changed my quote tags to code tags, but first I don't see a way to amend my thread title, and second - what should I put for title?? I can't really put it shortly - if you have any ideas, I won't mind changing it
Thanks.

P.S. I just found it! It wasn't easy to put both error messages for title though - because the problem is I get them for practically the same thing and I don't know what triggers them.
I am sorry for the mistakes I made while posting this thread - I am just over-exhausted at the moment...

About the search engine - I have been searching similar issues with these two messages in the last 4 hours without any luck. Then I have tried finding different ways to delete certain rows based on certain conditions - but that led me to nowhere as well. That's why I decided I should look for some help from people who know much more than I do

[shg]

The forum rules explain how to change your thread title.

The exact error message is a very good thread title, both here and in using a search engine.

[shg]

Can you post an example of before and after, illustrating what the macro is supposed to do?

[menyanthe]

OK. This is Before and After for both Sheet1 and Sheet2.
I am sorry for the low quality of the pictures.

[menyanthe]

OK, I am starting to get really confused now - I rewrote the code - to exclude some unintentional mistakes and here is what happened - it deleted rows it wasn't suppose to delete, deleted blank rows and none of the other rows. Also it gave me the same error as before - "object variable or with block variable not set" - only this time it was on the third valFoundRow line...
Also I tried using this code, but it didn't seem to do anything at all. I guess I am missing something but can't figure out what...

Please Login or Register  to view this content.

[Rick_Stanich]

Are you missing a right bracket here?

Please Login or Register  to view this content.

Should be?

Please Login or Register  to view this content.

[menyanthe]

Sorry, I just didn't copy it right...
I corrected it now - it should be OK now.

[menyanthe]

I fixed it... I used the second code I posted... The problem actually was that the cells contained not only the text values but also some empty spaces - so it couldn't find the value. Also, the cells, containing text "TRUE" which I wanted to delete - probably there was a conflict with the VBA script - since True is commonly used in it (although it shouldn't be a problem since I put it in quotation marks, but I guess it is just a bug). So, I had to use the Find and Replace function in Excel (Ctrl+F) and replace "TRUE" with something else. I, personally, replaced it with "absurd".

So, the problem was solved.