Cells.Find for text w/ line break

Excel Experts

In several headings, I have broken the heading over two lines by using
Alt+Enter to insert a line break between two words.

When I try to search for this text, the search fails.

In my VBA code, is there any way to successfully find this type of text.

Thanks,
Alan

--
achidsey

try this. i entered test <alt><enter>column in the B1, and i believe it was
norman's code i adapted


Sub tr()

With Columns(2)
Set fndRange = .Find(what:="test" & Chr(10) & "column",
LookIn:=xlValues)
End With
If fndRange Is Nothing Then
MsgBox "Not found"
Else
fndRange.Interior.ColorIndex = 35
End If
End Sub





--


Gary


"achidsey" <[email protected](notmorespam)> wrote in message
news:[email protected]...
> Excel Experts
>
> In several headings, I have broken the heading over two lines by using
> Alt+Enter to insert a line break between two words.
>
> When I try to search for this text, the search fails.
>
> In my VBA code, is there any way to successfully find this type of text.
>
> Thanks,
> Alan
>
> --
> achidsey

Gary,

Thanks. This will be very helpful. Alan

--
achidsey


"Gary Keramidas" wrote:

> try this. i entered test <alt><enter>column in the B1, and i believe it was
> norman's code i adapted
>
>
> Sub tr()
>
> With Columns(2)
> Set fndRange = .Find(what:="test" & Chr(10) & "column",
> LookIn:=xlValues)
> End With
> If fndRange Is Nothing Then
> MsgBox "Not found"
> Else
> fndRange.Interior.ColorIndex = 35
> End If
> End Sub
>
>
>
>
>
> --
>
>
> Gary
>
>
> "achidsey" <[email protected](notmorespam)> wrote in message
> news:[email protected]...
> > Excel Experts
> >
> > In several headings, I have broken the heading over two lines by using
> > Alt+Enter to insert a line break between two words.
> >
> > When I try to search for this text, the search fails.
> >
> > In my VBA code, is there any way to successfully find this type of text.
> >
> > Thanks,
> > Alan
> >
> > --
> > achidsey
>
>
>