How can i get the address or reference of the Merged cells.
i have few merged cells say,
A1,A2,A3 and A4
i am passing each cell value into an array. Now how do i get the value
of cell A2 or A3 or A4 ?
i am trying to validate if the cell is merged and getting the value
into array.
is thr some way tht after validating A2 is merged..i can go back to A1
and get the value?