none
Closed Worksheet Variable RRS feed

  • Question

  • I am trying to assign a worksheet in a closed workbook to a variable but keep getting a subscript out of range error.

    Is it possible to do this without opening the workbook? If it is then what would be the code?

    Thanks,
    SQL Servant
    Tuesday, June 26, 2012 4:22 PM

Answers