Search:

Type: Posts; User: Maudibe; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    8
    Views
    116

    IMHO, I like RG's approach with a UDF. It is so...

    IMHO, I like RG's approach with a UDF. It is so much easier to debug than nested if statements. However, the formula does seem to work. The if P3="" needs to be the first statement in its nested...
  2. Replies
    8
    Views
    116

    Try this: =IF(AN1="On-going",IF(P3="","No due...

    Try this:

    =IF(AN1="On-going",IF(P3="","No due date",IF(P3>42582,"On time",IF(AND(P3>42552,P3<42582),"In the...
  3. I believe this can be done with VBA that extracts...

    I believe this can be done with VBA that extracts the HTML coding from the CSV file by searching for table tags, wrapping them with HTML tags, and then creates an html file stored in the same...
  4. Replies
    4
    Views
    104

    Check this site...

    Check this site
    http://answers.microsoft.com/en-us/office/forum/office_2016-excel/need-to-open-xls-files-with-excel-2016win10/e6f1568f-e23d-4bcf-aa6d-742e625f0ec8?auth=1
  5. Replies
    17
    Views
    435

    Whereas, For I=2 to 14 does cause a "subscript...

    Whereas, For I=2 to 14 does cause a "subscript out of range" error.

    Perhaps better explained that Dim s(13) sets the upper bound of the array and in Option base 0, s(0) is nothing while in...
  6. Replies
    17
    Views
    435

    Excel, In your code, iRow evaluates to 0 so,...

    Excel,

    In your code, iRow evaluates to 0 so, Cells(iRow,1).value will error
  7. Replies
    17
    Views
    435

    RG, I look at it this way Dim s(13) As...

    RG,

    I look at it this way

    Dim s(13) As Variant means that the array holds 13 values whether For I= 1 to 13 OR For I= 0 to 12 (base 0 or 1)



    Public Sub LastUsedRow()
    Dim s(13) As Variant
  8. Replies
    17
    Views
    435

    Many ways to do this. Function without an...

    Many ways to do this.

    Function without an array



    Public Sub Caller()
    x = LastURow(1, 13)
    MsgBox x
    End Sub
  9. Replies
    17
    Views
    435

    As a function Public Sub Caller() x =...

    As a function



    Public Sub Caller()
    x = LastURow(1, 13)
    MsgBox x
    End Sub
  10. Replies
    17
    Views
    435

    excel, Consider the following alternative code...

    excel,

    Consider the following alternative code to find the last row in a range:



    Public Sub LastUsedRow()
    Dim s(13) As Variant
    '--------------------------------
    For J = 1 To 13 'COLUMNS A...
  11. Can you post the entire CSV file?

    Can you post the entire CSV file?
  12. Replies
    12
    Views
    763

    Is this for real?

    Is this for real?
  13. I am running versions of 2003, 2010, and 2013. ...

    I am running versions of 2003, 2010, and 2013. Although I do not have 2016, I am wondering if this could be an issue with trusted sites.

    Maud
  14. Bhush, I would take the approach of...

    Bhush,

    I would take the approach of designating a column for a time stamp that gets placed for each record as it is imported from your application with the criteria met. The code would finish up...
  15. Replies
    22
    Views
    479

    An alternative to Sumproduct using a UDF that...

    An alternative to Sumproduct using a UDF that will use any value including a 1

    As above, a helper column G. In G3, place the formula =COUNTA(B3:F3) then copy down to G7. This will count non blank...
  16. Replies
    22
    Views
    479

    Thanks RG but due to the nature of Sumproduct...

    Thanks RG but due to the nature of Sumproduct this only works if the values are only ones (as shown in dubdub's example). Perhaps, Countif(s) would work better if values can be other than a 1. Will...
  17. Replies
    3
    Views
    167

    Not sure if this is the case but your formula in...

    Not sure if this is the case but your formula in the second line may be evaluating to an error if you are not employing absolute referencing.

    Maud
  18. Replies
    22
    Views
    479

    dubdub, Thanks for the explanation. Would...

    dubdub,

    Thanks for the explanation. Would have never figured that is what you wanted to do. This can be don with a helper column G. In G3, place the formula =COUNTA(B3:F3) then copy down to G7....
  19. Replies
    5
    Views
    212

    jack, Thanks for the thanks. The formatting...

    jack,

    Thanks for the thanks. The formatting should follow the cell except for things like borders and conditional formatting. Can you post a sample ready for sorting so we can see the behavior...
  20. Replies
    22
    Views
    479

    dubdub, It's unclear how your matrix is setup....

    dubdub,

    It's unclear how your matrix is setup. But if it is how I suspect then this can be achieved with helper columns that indicate the duplicated values in each column.

    Next to the matrix,...
  21. Replies
    3
    Views
    175

    Zeno, Without using VBA, the best I could come...

    Zeno,

    Without using VBA, the best I could come up with using conditional formatting only is Change you formula to =N37<=10 then click on the "Format..." button and apply an Custom number format...
  22. Replies
    5
    Views
    212

    Jack, The above will copy the text and the...

    Jack,

    The above will copy the text and the formatting. Apply the same technique with the other ranges you want to copy.

    Maud
  23. Replies
    5
    Views
    212

    Jack, Try the following code: Private...

    Jack,

    Try the following code:



    Private Sub Worksheet_Activate()
    Sheets("General").Range("EdgePoint_Capital_Advisors").Copy _
    Destination:=Range("_216_831_2430")
    End...
  24. Nice job Howard!

    Nice job Howard!
  25. Howard, Glad to know that you can follow the...

    Howard,

    Glad to know that you can follow the code and the code from others. You have come a long way my friend!
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4