| Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Run-Time Error '13' Type Mismatch > Cell formats and values | Share |
Cell formats and values
Excel Help for Cell Formats And Values in Excel Multiple Regression Analysis and Forecasting Template
| Forum Topic | Login |
Cell Formats And Values | Rate this: (3/5 from 1 vote) |
 | Your code expects to find only strings (i.e. Text) in each cell. You will get a "Run-time error '13' Type Mismatch" if any of the cells are either formatted differently (e.g. a number) or are empty. If I were you, I would define your target cell as Variant then check to see if it is actually a string in the cell before doing the transform. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Cell formats and values in the Excel Business Solutions Directory |