Alternative VBA code

[pezalmendra]

Hello,

I am trying to use the following VBA code with no success. It give me error because there are too many arguments (i think). Does someone knows a shorter or better way to make use of this code?

Please Login or Register  to view this content.

Thank you very much.

Kind regards,

pezal

[Bernie Deitrick]

Split it up:

Please Login or Register  to view this content.

Or use the row number and math logic on the column (if your pattern of two columns every ninth column starting in column 12 holds for the entire range):

Please Login or Register  to view this content.

[AlphaFrog]

I think the Range object can take only 30 arguments at one time. You could combine multiple ranges like this...

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[pezalmendra]

Hi!

Thank you very much for your replies, they both work!

Kind regards,