Though I could get the row number of the top and bottom rows in a table (a formal table created by Insert:Table) or get the number of rows and then do a For/Next loop with a counter for each cell, is there a more efficient way to run through all the cells in a table column?
I need to verify that each cell has numerical data in it, if not then I either need to - extract it to numerical if it is a number that has been formatted as text or has any mistakes with leading or trailing text,
- otherwise change the entry to a "0".
Kind of wondering if there is a way similar when evaluating collections such as worksheets to using
where ws has already been defined as a worksheet type, other than making a class somehow out of the cells in the column!
Thank-you!!!
Bookmarks