Hey, try the IsNumeric function
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>
Sorry everything is so messy <total noob>VB:Dim FirstNumeric, i As Integer i = 0 For i = i + 1 If A_i = String Then Next If A_i = Integer 'or long, whichever works better Then A_i = FirstNumeric 'exit loop somehow End '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
Thank you so much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)