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!

  • Congratulations strongm 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. musha26

    Relative cell referencing

    Thanks Skip you're a star
  2. musha26

    Relative cell referencing

    I have a button in my work book, that is attached to a VBAmacro that runs a couple of modules and inserts the data in the desired celss, so this is the last part to the project
  3. musha26

    Relative cell referencing

    Hi skip I know how to so vlookups in excel, but i'm still new to Vba and have no idea how to do this, the column I want to retain is column A
  4. musha26

    Relative cell referencing

    Help please! I have a cell c8 in sheet1 whose value is from the result of the maxnumber in a table in sheet2. How do I insert in c9 in sheet1 the value in columnA in sheet2 corresponding to the same row the maxnumber was found? Basically in sheet2 column A represents dates so I would like to...
  5. musha26

    VBA subscript out of range error

    Thanks for all your help, that finally worked sorry had to rush to work, didn't have time to say thanks earlier.
  6. musha26

    VBA subscript out of range error

    I have changed the range to cell reference instead of naming the range. to "=min(b2:k1829)" My problem now is this range refers to a range in a different worksheet, ie(data) to the one the result is going in to ie(answer) So ewould I have to call the "=worksheets("data").range min(b2:k1829)
  7. musha26

    VBA subscript out of range error

    Thanks Skipvought and loomah. You were right I had the wrong spelling of the worksheet name. Now My code runs with zero as the annswer, but that is not the minimum value in the specified range.
  8. musha26

    VBA subscript out of range error

    Hi I have just started learning VBA and I have an error coming up "subs cript out of range error) I just have 2 workesheets in a workbook, one with a table of numbers, and I'm trying to get the minimum value within teh range and insert it in cell d5 of the previous worksheet. here's my code...

Part and Inventory Search

Back
Top