Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try
IF LEFT(cell.Value,1) = "(" Then --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kilcup " wrote in message ... Dear Tom, Thank you for your reply! I am getting an error message on the following line of the code that I copied from your reply: If Left(cell.Value, 1).Value = "(" Then This is the error message I received: Runtime error '424' Object Required Thank you again for any help you can provide. Jeff --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find specific info using search string using VBA | Excel Discussion (Misc queries) | |||
Find specific info within a text string using VBA | Excel Discussion (Misc queries) | |||
How to Find Specific Text in a Text String | Excel Discussion (Misc queries) | |||
Find specific value in a string | Excel Discussion (Misc queries) | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) |