Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kazoogal

    Reference a worksheet that is not active?

    oooh...I just tried this....not sure why it works though I changed the properties of the sheet and named it "shP01" and then I did: Dim mySheet As Worksheet Set mySheet = shP01 and it worked! ???
  2. kazoogal

    Reference a worksheet that is not active?

    Yes....it is Pzero1 in BOTH the macro AND the worksheet...I even retyped it....and am still getting the subscript out of range error - AHHHHHH Yes, the sheet is in the same workbook, different tab....
  3. kazoogal

    Reference a worksheet that is not active?

    Could someone please tell me how to reference another worksheet that is not the current and active worksheet? I'm sure its so simple... I've assigned a macro to a button on sheet1 that calls a module to access data from sheet2...however, no matter what I try I cannot select the sheet2. I'm...

Part and Inventory Search

Back
Top