Number of cells in merged cell
I just found my mistake. No more issue.
Thanks again Dave,
Brad
"Brad" wrote:
Hi Dave,
I'm trying to implement this using Cells(row,col).MergeArea, but it's not
working.
I really need to use Cells() and I don't want to set ActiveCell = Cells()
as I don't want to see the screen move all over the place.
Can this be done?
Brad
"Dave Peterson" wrote:
With ActiveCell.MergeArea
MsgBox .Rows.Count & vbLf & .Columns.Count & vbLf & .Address(0, 0)
End With
Brad wrote:
Thanks for taking the time to read my quetion.
I am trying to determine how many rows and columns are in my merged cell.
I can't seem to figure out how to do that.
I'm working with
If ActiveCell.MergeCells then
which tells me if the current cell is a merged one, but I can't get anything
else to work that will tell me how many cells are involved in the merge.
Thanks,
Brad
--
Dave Peterson
|