I have a spredsheet with merged cells and info in single cells in the next row,
I whant my sub to find the range of the merged cells but then set that range for the next row.
I have sumthing like - ma = Range("a3").MergeArea.Address
this gives me the address but I do not Know how to use it for the rest of my
Macro
I get ma to be for eg. "$A$3:$G$3" now I need to select the same columns but for next row ie. row 4
Please help
I whant my sub to find the range of the merged cells but then set that range for the next row.
I have sumthing like - ma = Range("a3").MergeArea.Address
this gives me the address but I do not Know how to use it for the rest of my
Macro
I get ma to be for eg. "$A$3:$G$3" now I need to select the same columns but for next row ie. row 4
Please help