Variable from Combobox not being accessed in my own sort subroutine

  • I made a VBA code that first reads the worksheet names into a combo box. Then I can select a worksheet and perform a SORT operation based on 2 criteria.
    The variable YY is declared as public in the form module so that it can be accessed in the SortThisWB module/ . On running the code It gives subscript out of range error. Any ideas on what is the issue here

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!