Method 'Sheets' of object '_Global' failed

[magesh_bala]

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

 

[ricasouz]

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)