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!

Recent content by mayki76

  1. mayki76

    using general variables

    thanks. problem solved - i figured global variables are active as long as you run all subs.
  2. mayki76

    using general variables

    that's exactly what i did but from some reason it doesnt work. i am not familiar with vba enough to understand why.
  3. 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")
  4. mayki76

    relative or absolute Rows and Columns indexes

    Hi Tony, thanks. i might got confused, but i see you managed to understand my problem.
  5. 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?
See more

Part and Inventory Search

Back
Top