A way to make a macro work on multiple sheets

[WraithGhost]

Good day,

I have a bit of a problem. I searched everywhere for a solution but found nothing that could help me.

I have this macro

Please Login or Register  to view this content.

And I have 34 sheets in which I want this macro to work, but in the workbook there are 36 sheets, the first 2 sheets should be excluded from this macro.

Here is the workbook with all the sheets http://www.sendspace.com/file/8458nn
The first sheet that should have the macro work on is sheet 103 Filipesti and the sheets to be excluded are Data and Centralizare Data.

In sheet 103 Filipesti is how the sheets looks before running the macro and in sheet 104 Filipesti is how it looks after running the macro.

Hope I've put all the information that was needed for someone to understand what I have and want to get.

Anyone has an ideea to how can I make this work?

Any and all help is appreciated

[AB33]

Use one of these in your code.

Please Login or Register  to view this content.

[Bishonen]

I can't access your file, but I'll try anyway:

Please Login or Register  to view this content.

[WraithGhost]

I get a compile error

"Next without For"

This is the code that i used

Please Login or Register  to view this content.

[Bishonen]

end with goes before next I

[WraithGhost]

Done that but it's not working.
It works only if I have an active sheet...

[arlu1201]

Also you can reduce your statements by half if you change this -

For e.g. from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[AB33]

Bishonen,
Thank you for correcting my error!
I think it would be easier for any one to see a mock workbook.

[WraithGhost]

The sample workbook is here
http://www.sendspace.com/file/8458nn
or
https://www.dropbox.com/s/n3158icauij4ext/sample.xlsm

Hope one of this links work

[AB33]

WraithGhost,
Sorry, it was my mistake.
Could you please change this line

Please Login or Register  to view this content.

in to

Please Login or Register  to view this content.

[WraithGhost]

Um...
It still did not work.
There are problems:
1. It did not select the third sheet and start to run the macro from there.
2. It did the same thing a bunch of times but on the same sheet, did nothing on the other sheets

This was the latest code used that had the above mentioned effects.

Please Login or Register  to view this content.

It would be great if you could see this damn sample file
https://www.dropbox.com/s/n3158icauij4ext/sample.xlsm

[arlu1201]

Why not upload the sample file here directly?

[WraithGhost]

sample.xlsm

Sorry, did not see the option before, looked for it but did not find it. Now I hope you can see the sample workbook

[AB33]

Okay, you have Pivot Table, shapes and merged cells.
Recently, I have learned that merging cells is a nightmare. They interfer with looping cells and I do not use them.

I have tieded up your code and is now short, but it is not working. I am sure Bishonen and Arlu will add thier ten cents.

[WraithGhost]

So you think that not merging would be better?

[AB33]

Wraith,
This site has been up and down since yesterday. I am unable to access it from time to time and even if I do, it is very slow.

[WraithGhost]

I think there's something with your connection, I did not have any problems with the site...

[arlu1201]

WraithGhost,

Is this sorted?

[WraithGhost]

No.

It did not work. Neither of the macros in the sample file given by AB33
worked...


In this file sample.xlsm you can see all the elements:
1. the first 2 sheets that need to be excluded from the code
2. the way the data looks in 103 Filipesti is exactly how it looks before the code that I've posted at first runs
3. the way it looks after the code was runned is in 104 Filipesti.

[pippo12345]

Try this:

Please Login or Register  to view this content.

Moderator Edit:

Welcome to the forum, pippo12345.

Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

[WraithGhost]

Thanks, pippo12345.

That was exactly what I wanted.
I guess that's the closest I can come to doing multiple sheets at the same time.