VBA running issues, needs to perform the VBA on ALL sheets with numbers

[jeroenft]

Dear all,

I am working on a VBA code and I came until this point that I want to multiple a sheet and give it a new name (a number). That is done . But after that another piece of the code needs to perform this on EACH worksheet, this is the part that is not working.

Please Login or Register  to view this content.

Can you please help me.

Best,

Jeroen

[HaHoBe]

Hi, Jeroen,

if you have solved the problem before anybody has answered please be kind enough to post your solution as a reference for other users who might face the same problem.

My suggestion would be something like

Please Login or Register  to view this content.

Ciao,
Holger

[jeroenft]

Hi Holger,

Your solution works way faster than mine does, so thank you very much and so sorry that I did not posted my solution.

Grtz,

Jeroen