Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have tried everything and the following statement always gives me an error:
Dim wks As Worksheet Set wks = Sheets("Columns") I have an .xls file that has some tabs in it for each "sheet". It turns out that Sheet3 is named by the tab "Columns". I was expecting to be able to access this sheet starting with the above statement. But the statement always throws an error Runtime error '1004': Method 'Sheets' of object '_Global' failed Why is it failing? How do I find out? Is this the correct syntax? Thank you. Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |