Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.13 seconds.

  1. Replies
    8
    Views
    205

    It's probably better to start your own question...

    It's probably better to start your own question for this.
  2. Thread: Mutiple Criteria

    by rory
    Replies
    3
    Views
    106

    You might also use:...

    You might also use:
    =IFERROR(LOOKUP(2,1/($A$1:$AA$1=A5)/($A$2:$AA$2=3600),A3:AA3),"")
  3. Replies
    8
    Views
    205

    You can specify the positions in the FieldInfo...

    You can specify the positions in the FieldInfo argument - e.g.:

    Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _
    FieldInfo:=Array(Array(0, 1), Array(32, 1),...
  4. Replies
    5
    Views
    136

    Where is Monserial declared (there should be a...

    Where is Monserial declared (there should be a Dim statement)?

    When using Find you should always check if the search value is found before trying to activate the found cell:


    Dim rgFound ...
  5. Replies
    5
    Views
    136

    It's a variable in your code. Can't say any more...

    It's a variable in your code. Can't say any more than that from the little you have posted, I'm afraid.
  6. Replies
    5
    Views
    136

    That error means that whatever value is in...

    That error means that whatever value is in Monserial is not found in the search range.
  7. Replies
    5
    Views
    174

    It would be much easier if you could repeat the...

    It would be much easier if you could repeat the account name for each signatory.
  8. Replies
    3
    Views
    154

    If you use FALSE as the final argument, the...

    If you use FALSE as the final argument, the filtering and sorting shouldn't affect the result. If you use TRUE, the table must be sorted in ascending order on column A.
  9. Replies
    3
    Views
    154

    Not particularly clear to me what you are doing...

    Not particularly clear to me what you are doing from that, but anyway...

    VLOOKUP takes no account of filters. Nor does any lookup function (other than DLOOKUP). The True/False only determines...
  10. Replies
    13
    Views
    380

    Yup. Selection in the former actually referred to...

    Yup. Selection in the former actually referred to a Textbox, not a Shape, and the Textbox does have a Characters property.
  11. Replies
    13
    Views
    380

    When you select an object, the Selection is not...

    When you select an object, the Selection is not necessarily the same object type as you selected originally. This is especially true of Shapes which can contain all manner of specific object types -...
  12. Replies
    13
    Views
    734

    I guess having to turn on iterations is a sort of...

    I guess having to turn on iterations is a sort of safety measure to avoid accidental circular references (which I see a lot of).
  13. Replies
    13
    Views
    734

    Cells have both a formula and a value (which is...

    Cells have both a formula and a value (which is why you can open a workbook that has links to other workbooks and choose not to update but have the original values of the formula calculations...
  14. Replies
    10
    Views
    286

    [SOLVED] Lou, A built-in accounting format should also...

    Lou,
    A built-in accounting format should also give you pretty much what you need though it would include a $ sign with the dash.
  15. Thread: Auto fill Formula

    by rory
    Replies
    6
    Views
    172

    Yes - sorry force of habit. You'd need to add: ...

    Yes - sorry force of habit. You'd need to add:

    Dim LR as long
    LR = Range("A" & Rows.Count).End(xlUp).Row

    then use that in RG's code too.
  16. Thread: Auto fill Formula

    by rory
    Replies
    6
    Views
    172

    And then: With .Range("L2:L" & LR) ...

    And then:


    With .Range("L2:L" & LR)
    .Offset(, -5).Value2 = .Value2
    End With
  17. Replies
    10
    Views
    286

    [SOLVED] Your formula does not actually return a blank...

    Your formula does not actually return a blank cell when linked to a blank or 0 cell, it returns 0 but the display of the zeroes has been turned off in the Options. You could achieve what you want by...
  18. Replies
    13
    Views
    297

    [SOLVED] Excel doesn't support Regex in Find/Replace I'm...

    Excel doesn't support Regex in Find/Replace I'm afraid. Has annoyed me for years.
  19. Replies
    13
    Views
    734

    To do it with a formula, you need to turn on...

    To do it with a formula, you need to turn on iterative calculation in Options, then create an intentional circular reference:

    =IF(A1>0,A1,B1)
    in B1 for example.
  20. Replies
    7
    Views
    363

    It is possible, though not officially...

    It is possible, though not officially recommended, to run both 64bit and 32bit versions of Office, though you can't have the same version in both 32 and 64 bit. You need to install 64 bit first...
  21. Replies
    4
    Views
    170

    You could also add a simple sum formula...

    You could also add a simple sum formula =SUM(B3:L500) to each sheet in say B2, then use:
    =SUMPRODUCT(SUMIF(INDIRECT("'"&TEXT(ROW(1:99),"00")&"'!I2"),I2,INDIRECT("'"&TEXT(ROW(1:99),"00")&"'!B2")))
  22. Just be aware that there is a bug in Windows 8 (I...

    Just be aware that there is a bug in Windows 8 (I am not sure if it persists in 10) whereby sometimes using the DataObject results in just two odd Unicode characters being put on the clipboard rather...
  23. Did you enable the add-in?

    Did you enable the add-in?
  24. Replies
    8
    Views
    270

    For basic colour CF it can be done but is not...

    For basic colour CF it can be done but is not that simple - see Chip's page here: http://www.cpearson.com/Excel/CFColors.htm

    If you have 2010 or later there is a much better option - the...
  25. Thread: Formula Rounding

    by rory
    Replies
    3
    Views
    158

    Just FYI, you can replace this: ...

    Just FYI, you can replace this:

    Right(Rng.Formula, Len(Rng.Formula) - 1)
    with just:

    Mid$(Rng.Formula, 2)
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4