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!

Recent content by fountain27

  1. fountain27

    Calling WorksheetFunction Rank

    No they are are positive values.
  2. fountain27

    Calling WorksheetFunction Rank

    I am trying to call the Rank function, but keep receiving the following error: Unable to get the Rank property of the WorksheetFunction class. Below is the code I am working w/ any suggestions?3 i = 15 Do Until IsEmpty(wsRawData.Cells(i, 2)) wsRawData.Cells(i, 1).Value =...
  3. fountain27

    End Property

    Tony, Thank you for the help. I now understand why the range did not expand. Skip, Sorry for the very vague question. Looking back it was pretty stupid. Take care.
  4. fountain27

    End Property

    Skip, I am still a little confused by your explanation. Can you briefly explain?
  5. fountain27

    End Property

    Does the end property not work when the range is more than one cell? Eg. Range("A1:R4").Select Range(Selection, Selection.End(xlDown)).Select Thanks.
  6. fountain27

    Excel: Number stored as text

    Geoff, Thanks that is extremely fast.
  7. fountain27

    Excel: Number stored as text

    Thanks to all for your time. Skip, I ended up using your code, it works much faster than my old worksheet function value().
  8. fountain27

    Excel: Number stored as text

    Thanks for information. It appears this custom function would work like the value(cell) function built into excel. I was hoping for a copy paste method, but I guess it can not be done. Things can never be too easy:) I really appreciate you taking the time to reply to my post. Take care
  9. fountain27

    Excel: Number stored as text

    Thanks for the fast reply. I tried that earlier, but since Excel does not view the item as a value * by 1 only returns a zero.
  10. fountain27

    Excel: Number stored as text

    I am working with a system that exports data into Excel. The numbers that are exported Excel stores as text, hence you can not perform any functions until the text is converted to a value. I have been using the worksheet function value(), but it is sloppy and causes my code to run slow. Is...
  11. fountain27

    Insert worksheet function when last cell is not constant

    Thanks. Works great. I fought w/ this for hours and it took you seconds. Humbling!
  12. fountain27

    Insert worksheet function when last cell is not constant

    I am trying to insert the "Subtotal" worksheet function into a cell where the "last cell" will change, hence changing the range of the function. Below is the code I am working w/ Set CellEnd = wsStrRpt.Cells((iLastrow + 1), 14) 'YTD CellEnd.Formula = "=SUBTOTAL(1,N12:N50)" I need to change...
See more

Part and Inventory Search

Back
Top