ExcelBanter - View Single Post

[email protected]

Great. Thank you.

davegb wrote:
wrote:
Is there a way to merge cells in VBA?

Selection.Merge

The easiest way to figure out something like this is to just record a
macro while you do it, like merging, then look at the macro. Works in
many cases. In some, a recorded macro does it differently than you'd
normally code it, but it's a start.