Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: How to detect whether two cells are currently merged
Using VBA, how can I determine whether two cells (let's say F8 and F9
for example) are currently merged? Thanks! Elieze -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect whether two cells are currently merged
Range("F8").merge.address<Range("F8").address
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Lazer " wrote in message ... Using VBA, how can I determine whether two cells (let's say F8 and F9. for example) are currently merged? Thanks! Eliezer --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect whether two cells are currently merged
Sorry, should be
Range("F8").mergearea.address<Range("F8").address -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... Range("F8").merge.address<Range("F8").address -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Lazer " wrote in message ... Using VBA, how can I determine whether two cells (let's say F8 and F9. for example) are currently merged? Thanks! Eliezer --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: How to detect whether two cells are currently merged
Go to Excel HELP and type
mergecells property In the Answer Wizard section. TH Cells(ActiveCell.End(xlDown).Row + 1, ActiveCell.Column).Select On 4/15/04 15:40, in article , "Lazer " wrote: Using VBA, how can I determine whether two cells (let's say F8 and F9. for example) are currently merged? Thanks! Eliezer --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy paste non merged to merged cells | Excel Worksheet Functions | |||
How can I sort an Excel Doc containing merged & non-merged cells? | Excel Discussion (Misc queries) | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |