Hi there,

Does anyone know whether it is possible to automate Excels 'Merge and Center' cells function in Visual Basic?

I have a daily report imported in html format, and when this is cut and pasted into excel where cells are hidden, resulting is columns not matching up. Currently I ctrl+a and hit the Merge and center button in the Formatting Toolbar.

Any help or advice would mostly be appreciated, Thank you.


Derek

Derek,

I'm not sure if this is what you're looking for - but you select a range in VB then simply:

Selection.merge

I had a similar issue and found that to work on my project.

Good luck!
-Michael