If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

Select only numeric values in a column

Hi guys, noobie here... I am stuck and would love some input!

What I have is a column that has several rows of string data, followed by rows of numeric data. The number of rows of numeric and string data may vary from sheet to sheet so I need to be able to find where the string data starts/ends and where the numeric data starts/ends. Any ideas?

<something along the lines of>

VB:

Dim FirstNumeric, i AsInteger
i = 0
For i = i + 1
If A_i = StringThenNextIf A_i = Integer'or long, whichever works betterThen A_i = FirstNumeric 'exit loop somehowEnd'Then take that data and use the first numeric entry in a range and copy it to a new sheet
Range(Range("FirstNumeric").End(xlToRight), Range("A9999").End(xlUp)).Select
Selection.Copy
Sheets("New_Sheet").Select
Range("A1").Select
ActiveSheet.Paste
Sheets("Original_Sheet").Select