Method 'Sheets' of object '_Global' failed

M

magesh_bala

Joined
Jun 28, 2005
Messages
1
Reaction score
0
Hi all,

I had this error throwing out by my application while running the same code for the second time without closing my application. The bunch of code which i am executing given below and i specified the exact line which one is creating the problem.

wb.Sheets("Costing").Select
wb.Sheets("Costing").Copy After:=Sheets(intI) '**** Error is occuring in this line ****'

I need to fix it urgently. Any one can help me to sort it out, it would be great.

Thanks in advance,

Balakrihsnan.K
 
If you see, when you use "Sheets" you must put "wb." and you have a "Sheets" with "wb." Loo:
wb.Sheets("Costing").Select
wb.Sheets("Costing").Copy After:=[Here ! Just put "wb." before]Sheets(intI) '**** Error is occuring in this line ****'

Ricardo Souza (Brazil)
 

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

Run time error 1004: Method 'Sheets' of object'_Global' failed 0
Method 'Cells' of object '_Global' failed - VBA 1
SQLServer 2017 exec xp_cmdshell 'dir Y:\*.*/s' command fails 3
Method 'Columns' of object '_Global' failed 2
VBA runtime error 1004; Method of 'open' of object 'workbooks' failed 1
simple macro to copy a sheet, object undefined error 7
method 'cells' of object '_global' failed 0
method 'range' of object'_global' failed 2

Back
Top