Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Macro to read Strings and Values in Rows
Joerd, Thank you very much for your help. I was unaware that the IsNumeric function could read through null values as well as bypass the strings. I have inputted your code into my spreadsheet and it works like a charm. I give you credit for helping me with my problem. Again, thanks a...- asumter
- Post #3
- Forum: -Engineering spreadsheets
-
Excel Macro to read Strings and Values in Rows
I am currently developing an Excel macro in VB that can format spreadsheets that I receive everyday. I have developed a code that reads down Column A which contains numeric values(0-10) in order to pinpoint the exact rows that I need formatted. For example, the code will read down Column A...- asumter
- Thread
- Replies: 2
- Forum: -Engineering spreadsheets
