Fill across all sheets except the first

[michaelkwc]

hello. i have a worksheet which contains a macro to process it, after which it will create an arbirtary number of worksheets after it. with a demo worksheet, it creates two worksheets after that, "yap" and "lam". i have this code to fill some data across these worksheets:

Please Login or Register  to view this content.

can someone please help me, how do i modify it to fill across every worksheet except the first worksheet, named "Original"? thanks a lot!

[rylo]

Hi


Try something like

Please Login or Register  to view this content.

HTH

rylo

[michaelkwc]

Please Login or Register  to view this content.

worked for me. thanks a lot!