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 Westi 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. Lodebo

    Vlookup

    Hi, I'm using this vlookup function : =VLookup(B6;[KW49_benodigd.xlsx]Mstock_grondstoffen!$B$22:$AD$84;29;False) As you can see "KW49" is a part of the worksheetname How can i replace "KW49" by a cell value ? Best regards, L.
  2. Lodebo

    Worksheet change event

    Combo, Thank you so much.... This works perfect !!!!! Best regards, Lode.
  3. Lodebo

    Worksheet change event

    Skip, Spot on, that's what i need. Combo, I don't understand how to implement this. thx guys
  4. Lodebo

    Worksheet change event

    Manually
  5. Lodebo

    Worksheet change event

    Thanks again Skip. The formula is the sum of some cells in another sheet. When the cell that contains the formula changes, then in the next column and same row i want the present date. That's all...[bigsmile]
  6. Lodebo

    Worksheet change event

    Thanks Skip, So there is no solution ? Hmmmm.....hard to believe[bigsmile] Lode.
  7. Lodebo

    Worksheet change event

    Hi, The range in this code contains formulas. When the values change the code does not work. I know it has something to do with the formulas but i can't find out what to do. Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Me.Range("E6:E31")) Is Nothing...

Part and Inventory Search

Back
Top