Conditional Merge VBA

[Vlad999]

Hi,

I am trying to write a VBA for merging cells if Column A contains text and the next 2 columns are blank then select that row from column A to column H and merge but am having problems with selecting the correct range have highlighted my error in red.

Please Login or Register  to view this content.

[mikerickson]

The argument of the one argument form of Range must be a string

Please Login or Register  to view this content.

. Here are a couple of of other options

Please Login or Register  to view this content.

I also avoid selection altogether, it slows things down and brings extranious factors (like which sheet is active) into everything.

Please Login or Register  to view this content.

[Vlad999]

Thank you works perfectly now

[Vlad999]

Sorry need a bit more help

now i'm trying to format the cells that are being merged. I can make the font arial, white and bold. But I dont know how to add in the two formatting styles below.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jasoncw]

Try this:

Please Login or Register  to view this content.

HTH

Jason

[Vlad999]

Thank you, just that i didnt explain myself well I wanted the Cell color to be green not the font...but thanks to you I figured out how to do it...much appreciated.

Please Login or Register  to view this content.