Macro not looking at all sheets

[Heinrich Venter]

Hi all

Hope you can help me. I am stuck on a macro im writing. It is only looking at the active sheet. I need it to look at all the sheets in the workbook.

Please see current coding below.

Please Login or Register  to view this content.

Thank you.
Heinrich

[Andrew-R]

You've told it to look at the active sheet,

Please Login or Register  to view this content.

Are you trying to get it to write to multiple sheets?

[Heinrich Venter]

Hi Andrew

Thank you for your reply.
No only to look at multiple but write to the one i run the macro in.

[Andrew-R]

At the moment your macro is set to only read data from sheet 1 in each workbook it opens.

If you defined a new variable as:

Please Login or Register  to view this content.

Then you could modify your code like this:

Please Login or Register  to view this content.