How to merge last used rows

[biznez]

Hi, im trying to merge A:C starting at row A5. I tried this code but its not working. Please help

Please Login or Register  to view this content.

Thanks

[Greg M]

Hi there,

It's hard to believe that you need to merge the cells in EVERY row of the worksheet - why not settle for a reasonable number of rows and use the following code:

Please Login or Register  to view this content.

The highlighted values can be altered to suit your requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M




P.S. If you want to merge the row cells and the column cells use the following code:

Please Login or Register  to view this content.

[biznez]

Hi there,

It's hard to believe that you need to merge the cells in EVERY row of the worksheet - why not settle for a reasonable number of rows and use the following code:

Please Login or Register  to view this content.

The highlighted values can be altered to suit your requirements.

Hope this helps - please let me know how you get on.

Regards,

Greg M




P.S. If you want to merge the row cells and the column cells use the following code:

Please Login or Register  to view this content.

Thanks so much !!

[Greg M]

Hi again,

Thanks for your reply - I'll assume that the code is doing what you want!

Best regards,

Greg M