Setting worksheet name to variable doesn't work

[mark hansen]

I have the following code that seemed to stop working...

Dim ws, bf As Worksheet

'On Error GoTo ErrHandler
Set ws = Sheets(8)
Set bf = Sheets(9)

When I step through it (F8) I get a Error 9 Subscript out of range. The code is on sheet 8 and I want to set WS as sheet 8 and BF as sheet 9.

What could cause this to stop working. It was working when I wrote and stepped through it before?

Thanks,
Mark

 

[mark hansen]

Thanks everyone, I appreciate the input. Preliminary testing has the Sheet8 working well. This is a big help and will go along way, most of all, it added to my foundation and explained the difference between sheet8 and sheets(8). It also explained what sheets(8) worked one time, but not after I deleted worksheets.