How many columns in a merged range

USAMax · Nov 13, 2013

I need to find the column after a merged range but I cannot find the right command.

I thought this would work:

Code:

Cells(RowFnd, y).Columns.Count

but it is giving me 1 when it should be give me 5 as J through N are merged on row 65.

Andrew Poulsom · Nov 13, 2013

Try:

Rich (BB code):

Cells(RowFnd, y).MergeArea.Columns.Count

USAMax · Nov 13, 2013

Thank you again Andrew!

I just came up with this:

Code:

                    Cells(RowFnd, y).Select
                    Test1 = Selection.Columns.Count

But I did not want to have to select the cells. You came through with the answer again!