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. topgrill

    code names

    you are right. i got the 424 message when i was trying to get my sheet2 and 1004 when i was trying to get sheet1. but i think the problem was that i was writing from personal.xls file. i have moved the macro to the same file as the one i was running it on and it now seems to work. wich leads...
  2. topgrill

    code names

    what do you mean by "VISIBLE"? i do not have any trouble selecting the sheet by other means in the VBA code (using Sheets(1).Select of sheets("mysheet").select) next to visible in the properties for sheet1 it says -1 -xlSheetVisible
  3. topgrill

    code names

    there are no spaces before or after sheet1. When i write Sheet1. there is a drop down menue. when i run sheet1.select i get the error run-time error '1004' method'select' of object'_Worksheet' failed
  4. topgrill

    code names

    no there is definately a sheet code name sheet1. i have just used MsgBox ActiveSheet.CodeName to double check and it is there.
  5. topgrill

    code names

    thanks but i think this is the crux of the problem, sheet1.select is not working. there is a sheet with code name sheet1. when i use this i get "Run-time error '424' object required" any clues?
  6. topgrill

    code names

    hi i am writing a macro that takes data from some sheets and colates it into one sheet. at the moment i am using Sheets(3).Select style of navigation, to move between sheets. i would prefer to use code names as they are a bit less prone to human error, but i am having getting to syntax right...

Part and Inventory Search

Back
Top