Re: Run-time error'9'

Or Try typing this

Dim sht as Worksheet

You have to type both the above just before set line