Capturing an error and then ignoring it

  • Thread starter Thread starter cskgg
  • Start date Start date
C

cskgg

Hi everyone, here is my problem:

Can any one pls tell me the code for telling the program to:
SELECT THE FIRST SHEET OF THE WORKBOOK (irresepctive of its name - i.e
the name of the first worksheet may be anything).

Many thanks guys! This forum is cool maaan.

Warm regards
CSKG
 
Use the NUMERICAL index..

dim ws as worksheet
dim sh as object
set ws = activeworkbook.worksheets(1)
'if you have charts..
set sh-activeworkbook.sheets(1)

or if you dont need the variable..
activeworkbook.worksheets(1).activate




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


cskgg wrote :
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Capturing an Error 1
Weird ignoring of one item in a loop 5
Macro for all Excel Workbooks to print to PDF 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
How do you capture the name of the current worksheet in VBA? 12
Need to embed a graphic, then make a call to it 9
Exporting Worksheets from a workbook and saving them as a .prn file 1

Back
Top