Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.83 seconds.

  1. Re: Error in code to save loaded pictures in userform to specific path

    What is the error message?
  2. Re: VBA Not Interpreting Single Quotes Correctly

    You have to double up any " marks that are part of the actual formula string:


    .Formula =...
  3. Replies
    2
    Views
    74

    Re: RANK gives different rank for same value

    If it's different when you paste it, then the stored value is not actually 5.3. There is almost certainly a very small difference in the stored values (Excel will actually store up to 17 significant...
  4. Replies
    3
    Views
    72

    Re: Indirect function on a Table Column name

    INDIRECT("FiscalYear["&A1&" Actual]")

    would be the equivalent.
  5. Thread: 64 bit issue

    by RoryA
    Replies
    5
    Views
    99

    Re: 64 bit issue

    Glad to help. It's always easy when you know how. ;)
  6. Re: VBA insert formula with relative cell references

    Glad to help. :)
  7. Replies
    6
    Views
    93

    Re: Save with references to unsaved documents

    You wouldn't have to actually have any code in there, just a reference set. It's the only thing I can think of offhand that could cause that message without appearing in the Edit Links dialog.
  8. Replies
    6
    Views
    93

    Re: Save with references to unsaved documents

    Do you have any references set to other files in the VB Editor?
  9. Replies
    6
    Views
    93

    Re: Save with references to unsaved documents

    If they are unsaved, they won't have a file extension yet, so a search for xl won't find them. What appears in the Edit Links dialog on the Data tab?
  10. Re: VBA insert formula with relative cell references

    You don't really need a loop:


    On Error Resume Next
    Sheet2.Range("w9:w" & lastRow).SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=IF((ISERROR(MATCH(RC[-1],'DEMPROG...
  11. Thread: 64 bit issue

    by RoryA
    Replies
    5
    Views
    99

    Re: 64 bit issue

    What reference are you using for the DAO? If it's DAO 3.6, that will not work in 64 bit Office. You'll need to replace it with the 'Microsoft Office 15.0 Access database engine Objects' reference.
  12. Replies
    5
    Views
    114

    Re: Formatting column with custom date format

    Glad to help. :)
  13. Replies
    5
    Views
    114

    Re: Formatting column with custom date format

    Sorry, misread your post. Use a colon in both the Find and Replace boxes instead of /
  14. Re: Chart based on table not updating as expected (VBA)

    Glad to help. :)
  15. Thread: 64 bit issue

    by RoryA
    Replies
    5
    Views
    99

    Re: 64 bit issue

    Change the API declaration code to:


    #If VBA7 Then
    Declare PtrSafe Function sndPlaySound32 Lib "winmm.dll" Alias _
    "sndPlaySoundA" (ByVal lpszSoundName As String, _
    ByVal uFlags As Long) As...
  16. Replies
    5
    Views
    114

    Re: Formatting column with custom date format

    Try selecting the column and then pressing Ctrl+H to bring up the Find/Replace dialog, then enter / in both the Find box and the Replace box, and press Replace All.
  17. Replies
    11
    Views
    134

    Re: VBA Code to Automatically Re-apply Filter

    Then it should only require something like:


    Worksheets("Totals").Autofilter.ApplyFilter
  18. Thread: 32 to 64 bit

    by RoryA
    Replies
    2
    Views
    155

    Re: 32 to 64 bit

    No version of the Common Controls library will work in 64bit Office.

    Not sure what you mean by "the online one", but the online version of Excel will not run VBA at all (and bitness would be...
  19. Re: Referencing controls on a userform that was created dynamically

    You're making this far harder than it needs to be by not following Norie's suggestion.

    To refer to controls on a loaded userform, you need a reference to that form, then simply refer to its...
  20. Thread: Sumproduct

    by RoryA
    Replies
    2
    Views
    38

    Re: Sumproduct

    You could use SUMIF for that:

    =SUMIF(Raw Data[Column1],TRUE,Raw Data[Count of Assets in BU])
  21. Replies
    11
    Views
    134

    Re: VBA Code to Automatically Re-apply Filter

    Is your data in a table, or just a normal range?
  22. Re: Chart based on table not updating as expected (VBA)

    Like this (I added comments so hopefully it's clear what is happening):


    Sub TestChart()

    Dim lo As ListObject
    Set lo = Sheet2.ListObjects(1)
    ' clear data part of table and resize to...
  23. Replies
    11
    Views
    134

    Re: VBA Code to Automatically Re-apply Filter

    The autofilter object has an ApplyFilter method which will reapply whatever filters are currently set.
  24. Re: Increase / decrease arrows based on what user types in

    I think your biggest problem will be determining when to update. If you have three components that make up the score, presumably they could update any combination of those, and in any order, and you...
  25. Re: How to include double quotation marks in a formula in vba

    The formula syntax is OK, assuming that M11 is actually part of the table? If not, you would get an error as the formula is missing a table name.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4