Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As per this thread
http://www.microsoft.com/office/comm...a-1ed27880f1b5 set r = .Find(" - Open Positions ( August 03, 2007 )") returns nothing even though there is cell with that value The only peculiarity of that cell is that is merged with others Is the find function not supposed to work for merged cells? Thanks, Antonio Code and sheet follows: Sub main() Dim r As Range Dim match_address As String Dim st As String st = Worksheets(1).Range("A3").Value With Worksheets(1).Columns("A") Set r = .Find(st) If Not r Is Nothing Then match_address = r.Address End If End With End Sub ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Potential Bug in Find All application | Excel Discussion (Misc queries) | |||
Script doesn't work when cells are merged. | Excel Discussion (Misc queries) | |||
Clear Contents won't work on merged cells | Excel Programming | |||
Autofit doesn't work with merged cells | Excel Discussion (Misc queries) | |||
Code doesn't work on merged cells | Excel Programming |