Find same result on multiple sheets

[stojko89]

Hi,

I have a workbook with a few worksheets.
I found a way to find the same result on all the sheets with Ctrl+F and search the whole workbook.
But I made a userform that would search for the results on the sheets and enter some data in columns next to the found result.
So I don't have to go to every cell with the value I'm looking for and then write/Copy data in the cells.

My code works for the active sheet.
But I don't know why it doesn't work for the whole workbook like I'm tryn to tell it to
If someone could help me out with this please:

Please Login or Register  to view this content.

[StephenR]

All your ranges need to be qualified by worksheet references.

[stojko89]

you mean like:

Please Login or Register  to view this content.

?

isn't there a way to loop through the sheets? :O

[StephenR]

Your code already loops through and uses the variable ws so you only need to repeat what you have done in your second for each line.

[stojko89]

I wasn't sure what you mean by that I have to do the same in my second For Each Line...
But I tryed to add a ws.Activate to the code and it works.
I've just disabled and Enabled Screen updating so I don't get the fast page flashing
Here is my code now, unless u had something else in mind:

Please Login or Register  to view this content.

[StephenR]

That's the gist of it but you could have just done this which avoids activating sheets which is not necessary and inefficient:

Please Login or Register  to view this content.

[stojko89]

Ah...forgot about that
Thank you for your help!