I'm trying to do an autofill and part of the source range for the autofill has some merged cells.
I keep getting the error:
"This operation requires the merged cells to be identically sized."
I made a brand new test sheet (didn't screw with column or row widths) and merged, A1 and B1 and placed the number 1 in it. I then merged C1 and D1. When I tried to do an autofill in VBA -
sheets("Test").range("a1:b1").autofill destination:=sheets("Test").range("a1:d1"), Type:=xlfilldefault
it gave me the same error message (see above).
Can anyone tell me what this error message is referring to?
I keep getting the error:
"This operation requires the merged cells to be identically sized."
I made a brand new test sheet (didn't screw with column or row widths) and merged, A1 and B1 and placed the number 1 in it. I then merged C1 and D1. When I tried to do an autofill in VBA -
sheets("Test").range("a1:b1").autofill destination:=sheets("Test").range("a1:d1"), Type:=xlfilldefault
it gave me the same error message (see above).
Can anyone tell me what this error message is referring to?