help with on error resume next

[leanne2011]

Hi - can someone help me please. I have a number of columns that I wish to find in a spreadsheet so I repear the following on error resume next. But after it test's the cells.find it still copies the info and pastes it when I want it to ignore and to go to next test. Is there an easy way of doing this?

Many thanks

Please Login or Register  to view this content.

[romperstomper]

You don't really need an error handler with find if you assign it to a range variable.

Please Login or Register  to view this content.

[leanne2011]

It displays an error at this point - (run time error - 13, type mismatch)

Please Login or Register  to view this content.

So I have changed to

Please Login or Register  to view this content.

but still another error

run time error 424

at the point of

Please Login or Register  to view this content.

[watersev]

hi romperstomper, is it a typo or sort of educational trick?

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

[romperstomper]

Both were typos (the dangers of untested code):

Please Login or Register  to view this content.

[watersev]

hi leanne2011,

it should be:

Please Login or Register  to view this content.

plus see post #4

[leanne2011]

Ok this is perfect - thank you. Just one problem though, in the first column it is going to the last row of data and copying and pasting but when it goes to the varFindItems its one row sort in the copy and paste function ?

[leanne2011]

not sure if i was clear - the first time the procedure is run and in the 1st varfinditem, the copy and paste is the exact rows ie activerows but when it reruns the procedure 2nd time and onwards its 1 row short in copying the data across.

[romperstomper]

Be easier to say why with a sample workbook and all of your code.

[leanne2011]

Be easier to say why with a sample workbook and all of your code.

Thanks for your help on this

Please Login or Register  to view this content.

[leanne2011]

can anyone please help me with this

[romperstomper]

I'm afraid I am quite busy at the moment, but I will try and take a look at lunchtime if no-one steps in before then.

[romperstomper]

Can you give me a specific example as to what is missing on subsequent runs?