Hello surk,
Merged cells are referenced using the upper left cell in the merged range. If "I10:R12" is merged as a single cell then you would reference only "I10". If you have 3 rows "I10:R10", "I11:R11", "I12:R12" then the same rule applies.
Is "C8:D8" also a merged cell?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks