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 IamaSherpa 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. capetownandre

    Excel - Good way to paste in formulas?

    Assuming the X,Y,Z are columns A,b,c and the data starts in row 2 the folowing will work, can be draged down for all rows =RANK(B2,INDIRECT(("B" & (TRIM(A2)*3) -1 & ":B" & (TRIM(A2)*3) +1 )),1)
  2. capetownandre

    average for cell using FormulaR1C1

    dont understand why you are wanting to place a formula in a cell programatically. surley is better to place the result of the formula in the cell, that way the worksheet does not have to recalculate the values everytime you display them. Or am I missing something use a variable to build the...
  3. capetownandre

    Get values from a a filered excel sheet

    Ok this was pretty instant for me using 40000 rows Dim mymessage As String Set r = Worksheets("sheet2").Range("a1:a40000") mymessage = "" For n = 1 To r.Rows.Count If r(n).RowHeight > 0 And r(n, 1) > " " Then mymessage = mymessage & vbCrLf & r(n, 1) & " " & n...
  4. capetownandre

    Get values from a a filered excel sheet

    The rowheight of the cell will be 0 for the unfiltered rows therfore loop through cells check if rowheight > o Hope this helps
  5. capetownandre

    Starteam API

    Trying to access a Borland starteam folder from within VBA. Does anybody have any examples of how to navigate the API. I can sucessfully connect, but am having trouble navigating from views to folders & Files '///////////////////////////////////////////////////// Sub CommandButton1_Click() '...

Part and Inventory Search

Back
Top