Sorting Integers in VB Excel

[bobo6429]

Is there a way to identify an integer as a category using Excel VBasic? I have a LARGE document, and I need to get rid of superfluous data. I want to eventually remove rows that don't start with an integer from the worksheet, but first I need a way to automatically differentiate between integers and strings as categories. Please help, and thanks in advance.

 

[RoryA]

You can use a formula like:
=ISNUMBER(A1)
to identify whether a cell contains a number or not. (This returns TRUE or FALSE) You can then use this with an autofilter or a sort to easily extract rows that have a number in column A from those that don't. Does that help?

 

[bobo6429]

yes that should work, but how would I get visual basic to apply the formula?

 

[RoryA]

Something like:

Sheets("sheet name").Range("B1:B1000").FormulaR1C1 = "=ISNUMBER(RC1)"

 

[bobo6429]

that worked swimmingly! thanks a lot.