Working with Merged cells

Couldn't find another post about this so hope I am not re-posting an already answered question.

I am trying to auto format some merged cells within a sheet based on the information in them.

Anyone know how to reference the information within theses cells?

Thanks

Basically, you should avoid using Merged Cells. They are one item MS should remove from Excels features.

Are you using Conditional Formatting? Why not attach an example workbook?

Here's an example of merged cells with Conditional Formatting

hi Timtrag12,

Welcome to the Forum

Merged cells are not recommended as they can cause all sorts of problems in spreadsheets. Are merged cells really necessary in your spreadsheet?

Here are some links & info that may help you:
http://www.excelforum.com/excel-prog...a-macro-2.html
(Shows how you can loop through all merged cells on a sheet)

Excel 2007 VBE Help Files

Range.MergeArea Property
Returns a Range object that represents the merged range containing the specified cell. If the specified cell isn’t in a merged range, this property returns the specified cell. Read-only Variant.

eg

Please Login or Register  to view this content.

To help us help you further (if the above is not enough info), can you please upload an example file with "before & after" & explanation?
Edit: I posted before seeing Roy's posts, but repetition is the key - a sample file will make things much easier...

hth
Rob

You should only use VBA when necessary,always use Excel's built-in features first