Problem Merging Cell in VBA.

[d34n0]

Sheets("A").Select
Range("C65536").End(xlUp).Offset(1, 0).Select

The above code makes the selection of the cell i want but how can i select the cell below it at the same time and then merge the two cells?

Thanks

 

[Norie]

Do you actually want to merge the cells or combine the contents?

Perhaps

Sheets("A").Range("C65536").End(xlUp).Offset(1, 0).Resize(2, 1).Merge

 

[d34n0]

It works a treat. Thanks again Norie