MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel Merge Cells

  Asked By: Sherry    Date: Oct 05    Category: MS Office    Views: 2467

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?



2 Answers Found

Answer #1    Answered By: Kian Evans     Answered On: Oct 05

if range("a1").merged then
do something
do something else
end if

Answer #2    Answered By: Tomas Thompson     Answered On: Oct 05

You can change the coding to

Range("A1").MergeCells = True

it will help you out.

Didn't find what you were looking for? Find more on Excel Merge Cells Or get search suggestion and latest updates.