如何先判断出单元格是否参与合并,然后将参与合并的单元格的值设为合并单元格的值?
Dim cell As Range
Dim cellAddr As String
dim MergeCount as integer '合并区单元格总数
dim rStart as integer '合并区起始单元格行号
dim cStart as integer '合并区起始单元格列号
dim rCount as integer '合并区行数
dim cCount as integer '合并区列数
Sheets("Sheet1").UsedRange.Rows.Select
For Each cell In Selection
If cell.MergeCells = True Then '判斷是否為合并的單元格
cellAddr = cell.Address '取得該合并的單元格地址
MergeCount=cell.MergeArea.Count '合并区单元格总数
rStart=cell.MergeArea.Row '合并区起始单元格行号
cStart=cell.MergeArea.Column '合并区起始单元格列号
rCount=cell.MergeArea.Rows.Count '合并区行数
cCount=cell.MergeArea.Columns.Count '合并区列数