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 bkrike 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: *

  • Users: mayki76
  • Content: Threads
  • Order by date
  1. mayki76

    using general variables

    i am writing a macro for excel. i have few subs. there are some variables (like "file_name") which i would like to use in all the subs. how to i do so? (i declared them in the "general")
  2. mayki76

    relative or absolute Rows and Columns indexes

    I am using FormulaR1C1, as in: Worksheets(sheet1).Range("b5").FormulaR1C1 = "=R[1]C[2]" Sometimes the index will be raltive to the current cell (in this case, "c7") and sometimes absolute (in this case, "b3"). How can I conrtol it?

Part and Inventory Search

Back
Top