| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Address of merged range VBA
I am trying to return the address of the top left cell in a merged
range. thsi is what I have so far and it is not even close to right. Set Rng = Range("A52:BS52").Find(what:=ComboBox1.Text, lookat:=xlWhole, _ Searchdirection:=xlPrevious, MatchCase:=False) MsgBox Rng.MergeArea.Resize(1, 1).Address Thanks, Jay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| How to find the address of the min cell within a range | Excel Worksheet Functions | |||
| my merged address labels are only printing ONE page -- answer? | Excel Discussion (Misc queries) | |||
| Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
Threaded Mode
