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 Rhinorhino 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: danane
  • Content: Threads
  • Order by date
  1. danane

    sorting values in a range

    I want to sort a range. The problem is that the cells in column M have formulas like =MIN(H3:K3). I only want to sort the values, not the formulas. I made a code, but the XLVALUES or something like that is missing. I don't know where to put this in ... Thanks for helping. Code...
  2. danane

    delete cells according to criteria

    I've got a table 1 and a table 2. In both tables, there are many entries. Well, I want to delete all entries in the table 1 that do not exist in table 2. I don't know how I can manage to do this task. Thanks a lot for your help!!! example: FIRST: table 1: table 2: dog dolphin...
  3. danane

    Array Problem

    Hello, I always get the following error-message:"Subscript out of range." Please help me finding the mistake in the code. Thanks!! Dim z As Integer Dim Arr() As String Dim intcounter As Integer With Application.FileSearch .NewSearch .LookIn = "C:\Lists" .FileType = msoFileTypeAllFiles...

Part and Inventory Search

Back
Top