Merge Cells in VBA
 

Is there a way to merge cells in VBA?

Merge Cells in VBA
 

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.

Merge Cells in VBA
 

Do you want this ??

Sub test()
Dim cell As Range
Dim str As String
For Each cell In Range("A1:A10")
str = str & cell.Value
Next cell
MsgBox str
End Sub


--
Regards Ron De Bruin
http://www.rondebruin.nl



wrote in message oups.com...
Is there a way to merge cells in VBA?

Merge Cells in VBA
 

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.

Merge Cells in VBA
 

Nope. I wanted Selection.Merge

Ron de Bruin wrote:
Do you want this ??

Sub test()
Dim cell As Range
Dim str As String
For Each cell In Range("A1:A10")
str = str & cell.Value
Next cell
MsgBox str
End Sub


--
Regards Ron De Bruin
http://www.rondebruin.nl



wrote in message oups.com...
Is there a way to merge cells in VBA?