I'm trying to programmatically grab data from a string which is located in xlsheet.Range("A" & i) row by row. With Mid, Instr, and Right split up the line of data where be needed and insert Columns to divide the string. Any ideas?
My original approach was to grab the first section of data from the string, insert a column (Shift:=xlToRight), then paste. Once I've grabbed all the data I would delete the last column holding the original string. Is there any easier way?
My original approach was to grab the first section of data from the string, insert a column (Shift:=xlToRight), then paste. Once I've grabbed all the data I would delete the last column holding the original string. Is there any easier way?