John Skolits
askolits at ot.com
Tue Jun 19 17:36:12 CDT 2007
This has to be a no brainer. Using VBA I just want to select an Excel sheet and select a cell. Set objXLBook = GetObject("c:\test.xls") I can make the correct sheet active by using: objXLBook.Sheets("Sheet2").Select but then can't select the cell. I tried objXLBook.Range(.Cells(1, 2)).Select or objXLBook.Range("B1").Select What's the correct syntax? The error I get is "Object doesn't support this property or method" Maybe I shouldn't be using the "Range" reference? John Skolits