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

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

    Executing mouseclickc

    Hi, does anybody know how to execute a button without clicking it? Application.Run"ExcelName.xls!Buttonname" doesn't work Thanks, vix
  2. vixvee

    End of Column Entry Autofill

    Hello, Can anybody help me do autofill of column upto last entry adjacent to it? 1 entry1 2 entry2 3 entry3 : : : : N entryN Where N is not known and can be any number and the entries can autofill upto this N column. Thanks, vix
  3. vixvee

    Looping Column in a Formula

    Hi, For example I want to put this formula in a loop. ActiveCell.FormulaR1C1 = _ "=INDEX('[Name.xls]L'!R[-11]C[-3]:R[50]C,MATCH('[Name.xls]L'! CELL_LOOP ,'[Name.xls]L'!R[-11]C[-3]:R[50]C[-3],0),3)" How can I make CELL_LOOP into a column array? How should I construct the...

Part and Inventory Search

Back
Top