I have a spredsheet with merged cells and info in single cells in the next row,
I whna 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

Please help