Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am serching for a string but the string seems to have an invisible control
character - probably Chr(13) or something of the like at the end. My script is : Range("A2").Select 'Set for start range Do Until ActiveCell = "" If ActiveCell = "Gobbledegook" Then 'Test to find vText = ActiveCell.Offset(1, 0).Value 'Grab data ActiveCell.Offset(1, 14) = vText ' Copy it End If With this hidden character I cannot use the search! How can I find the cell ignoring the character(s) Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hidden Character | Excel Worksheet Functions | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Hidden Character Find Macro Help | Excel Programming | |||
How do I delete hidden character in Excel? | Excel Discussion (Misc queries) | |||
Function to return Character Position of Xth character within a string | Excel Programming |