Run Macro on few Sheets

[herverob]

Hi All,
I am having a problem with DIM...I guess

I would like to run a macro on few sheets.
For that, I think the best way would be FOR...NEXT

On the attach file, I would like to put a yellow color on cell A1 for the sheets listed on SUMMARY, Cell B5 to B8.

Thanks for your help

Herve

[StephenR]

Yes, just a syntax error. Try this:

Please Login or Register  to view this content.

[herverob]

Thanks Stephen
works great.