Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with cells that generate errors
Hi all,
I have an excel workbook where I read in text strings and then do some manipulation of these strings. Some of the data is freeform text, and sometimes the text itself causes errors. For example, if I have a cell with contents something like "=-\tSome Words" (without the quotes). This string causes a NAME error. What I want to be able to do, in VBA, is read in the text string to a value and move it to some other cell. Every time I do this I get an error 2029, or a "Type Mismatch" error (Err.num=13). I understand I can put an apostrophe in front of the text. Problem Is I get an error any time I reference the cell, so I cannot read it in to a string variable to add the apostrophe. What is a good way to handle this situation? TIA! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
working around errors - simplified | Excel Discussion (Misc queries) | |||
Error trapping is not working for errors related to files | Excel Programming | |||
Count cells with numbers and ignore cells with errors | Excel Discussion (Misc queries) | |||
Shell Object Not Working Right In XL2000, But No Errors | Excel Programming | |||
How do I generate Errors for Drop-Down Lists? | Excel Discussion (Misc queries) |