I have activated the worksheet that i am trying to get to in Excel. However, VB will recognize the default worksheet and will not read any values from the activated worksheet. All the worksheets are located in the same workbook. Code is as below:

Workbooks(lateruse).Sheets(excelinfo3).Activate
'Later Use is the C:/ Filename** 'EXCELINFO3 is the SHEET NAME'
ActiveWorkbook.Worksheets(excelinfo3).Activate

'EXAMPLE DO FOR LOOP TO SEE IF VB SEES NEW SHEET
Do Until InStr(Excel1.Cells(row, col), "Group")
a = Excel1.Cells(col, row).Value
row = row + 1
Loop
'EXCEL RETURNS DEFAULT SHEET VALUES

HELP!!

Thanks in advance!!
~Jason