Select all Sheets Error

  • Thread starter Thread starter dolphinv4
  • Start date Start date
D

dolphinv4

Hi,

I tried to select all sheets in a database i have by
having this macro:

Sub Test()

Sheets.Select

End Sub

but there is an error "Runtime Error 1004 -
Method 'select' of object 'Sheets' failed".

However, when I open a new workbook and do this, the
macro works. Why?

Regards,
Val
 

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

Select drop down menu option using libre-calc macro 0
Selecting Precedents On Other Sheet Via Macro 3
Excel 2007: Help creating a macro that will run Solver? 3
Sheet Macro Help Needed 4
VBA error 6
Run-time error "1004" Select method of range class failed 3
Error in Macro 2003 2
Paste method error in macro 2

Back
Top