Suddenly getting Subscript out of Range error

[lockarde]

Good morning all,

I have a spreadsheet that I've used for several weeks - it worked just fine yesterday in fact. Today I turned my computer on, opened the workbook, and suddenly I'm getting a Subscript out of Range error for the following line:

With ThisWorkbook.Sheets("Job Results")
''some code
Set findcush = .Range("E20:E50").Find("Cushioning", LookIn:=xlWhole) ''error on this line
''some more code
End With

As I said, I literally just opened it, so I haven't made any changes to Sheet name, or anything. I read another post that said try referring to the Sheet via code name, in this case would be Sheet1. I still get the error. Any thoughts on this? I'm very confused - any help is greatly appreciated!

lockarde

 

[dmt32]

try changing that line for this

Set findcush = .Range("E20:E50").Find("Cushioning", LookAt:=xlWhole)

and see if resolves

Dave

 

[lockarde]

try changing that line for this

Set findcush = .Range("E20:E50").Find("Cushioning", LookAt:=xlWhole)

and see if resolves

Dave

Welp, that worked! Thanks, Dave! I realize now that I had incorrect syntax in there - so that begs the question, why has it been working until today? Probably a Monday question though....

 

[NoSparks]

Microsoft just updated my computer this morning, including things for my Office 2010, so perhaps it's an update that now picks it up.

 

[lockarde]

Microsoft just updated my computer this morning, including things for my Office 2010, so perhaps it's an update that now picks it up.

Certainly could be the case - probably for the best, since it's catching my bad syntax. Thanks for the response NoSparks

 

[dmt32]

Welp, that worked! Thanks, Dave!

Glad resolved - as already mention, maybe an update caused the issue for you.

Dave