Referring to merged cells

[wayneao]

I'm trying to find out how to refer to merged cells.

e.g. Cells b2, c2, d2, e2 have been merged into one cell.

I've vb code how can I refer to that merge cell.

When I palace code it says that you can't use code in merged cells


Also this code works but is there an easier way to write it?

Range("G4").ClearContents
Range("G13").ClearContents
Range("G22").ClearContents
Range("G31").ClearContents
Range("G40").ClearContents
Range("B12").ClearContents
Range("B21").ClearContents
Range("B30").ClearContents
Range("B39").ClearContents
Range("B48").ClearContents

wayneao

[LJMetzger]

Hi wayneao and welcome to the forum,

1. See the code in post #14 of the following thread concerning VBA code and merged cells: http://www.excelforum.com/excel-form...ml#post3756729 In general, you can only access the 'top left' cell of a Merged Cell.

2. I think your 'ClearContents' code is fine as is, since you are clearing non-contiguous areas.

Lewis

[wayneao]

One suggestion was to rename merged cell.

I tried that and it worked fine but i was hoping that there might be an easier was to do it.

By the way the code for the merged cell is to clearcontents.

It run through a button on click.

[kvsrinivasamurthy]

It is better to use,

Please Login or Register  to view this content.

[wayneao]

Thanks for the clarification.
I'm new with excel and not use the code procedure. So little tips like this are helpful.

Thanks again
Wayneao

One other thing. When I go to my posts it only shows two replies yet the are four in total. How do I see the other two?