Forum Discussion
Run-time error'9'
Hello all, my company uses the excel spreadsheet for the majority of our companies operational records. I recently ran into a problem using a macro. 1. We have what is called a "lead sheet". On t...
Josh2153 You havent used the DIM for sht variable try typing
DIM sht as Workbook and then try again executing it.
Please let me know if it doesnt work
Or Try typing this
Dim sht as Worksheet
You have to type both the above just before set line
Dim sht as Worksheet
You have to type both the above just before set line