Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.88 seconds.

  1. 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...
  2. 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.
  3. Replies
    2
    Views
    51

    Re: Array not erasing

    Erase empties an array, it does not resize it. Either use variants instead and assign Empty to them when done, or use a Redim without Preserve to resize them as required.
  4. Re: Chart based on table not updating as expected (VBA)

    I'd suggest you stop clearing the existing table and then adding a new one, and simply overwrite the data rows of the existing table.
  5. Replies
    5
    Views
    184

    Re: Initialising a class

    And if you want a really fun way to do it: https://rubberduckvba.wordpress.com/2018/04/24/factories-parameterized-object-initialization/
  6. Re: Calculated Fields Greyed out in Pivot Table with Data Model

    Are you certain it wasn't added to the data model? Can you use a Distinct Count function on a value field? (If so, it's in the data model)

    For a regular pivot table, calculated fields should be...
  7. Re: MS Excel for Mac 2011 - VB Ver 14.0 - Escape Key capture

    Do you have a button on the form to close it, whose Cancel property is set to True? If not, pressing Esc shouldn't do anything at all.
  8. Replies
    6
    Views
    144

    Re: VBA autofilter - filter blanks only

    That could be the problem. If you paste a cell containing "" (as the result of a formula) as values, the cell isn't considered truly blank. So you'll need the autofilter and delete visible cells.
  9. Re: Excel 2019 macros error: "Excel cannot load two files with the same name"

    The buttons on the ribbon are linked to macros in a particular file. If that file is not in the same location as the already open file with that name, then Excel will try to load the new file, hence...
  10. Replies
    8
    Views
    124

    Re: Populate Range from string

    rng is a Range object, so all you should really need is:


    Private Sub cmdApply_Click()
    rng.Value = Me.txtTest
    End Sub
  11. Re: MS Excel for Mac 2011 - VB Ver 14.0 - Escape Key capture

    Did you set a Cancel button?
  12. Re: VBA grammar for sum of two fields in SQL table

    Not that I am aware of.
  13. Re: How to count SPECIFIC text characters with a range of cells

    Glad to help. :)
  14. Re: VBA grammar for sum of two fields in SQL table

    As I said, you don't need Array at all. And yes, each element is limited to 255 characters.
  15. Replies
    5
    Views
    171

    Re: Styles of programming in VBA

    Depends on the situation; could be overkill, or entirely reasonable!
  16. Re: why am i seeing this each time i open a new Excel Workbook

    That sounds like perhaps your options had been changed to open all files in that folder at startup. I'd suggest that fixing that was a better option than deleting the add-ins themselves.
  17. Re: For Each Visible cell in range, get me the left 6 characters

    That is writing to column W. cl is the visible cell at each iteration, and 22 columns to the right of column A is column W.
  18. Re: why am i seeing this each time i open a new Excel Workbook

    There is no need to actually delete them. You can, as Jan Karel already stated, just uncheck them in the Addins dialog box, so they don't load when Excel starts.
  19. Re: For Each Visible cell in range, get me the left 6 characters

    What's the value of LastrowAD when the code runs?
  20. Thread: Runtime Error

    by RoryA
    Replies
    10
    Views
    271

    Re: Runtime Error

    As I said, that is absolute gibberish. What you posted will not compile or run.
  21. Thread: Runtime Error

    by RoryA
    Replies
    10
    Views
    271

    Re: Runtime Error

    That code is complete gibberish. I think you might need to reinstall.
  22. Replies
    4
    Views
    50

    Re: Creation of IP Address Ranges

    You could use:

    =TRIM(LEFT(SUBSTITUTE(A1,".",REPT(" ",1000),3),1000))&".10"
    =TRIM(LEFT(SUBSTITUTE(A1,".",REPT(" ",1000),3),1000))&".99"
  23. Replies
    5
    Views
    171

    Re: Styles of programming in VBA

    You're already familiar with classes and hierarchies from the Excel object model - eg Workbooks and Worksheets.
  24. Re: VBA grammar for sum of two fields in SQL table

    Don't use the Array function there. Just use:


    .CommandText = "SELECT...."
  25. Re: How to count SPECIFIC text characters with a range of cells

    You could use:

    =SUMPRODUCT(LEN(B11:AF12)-LEN(SUBSTITUTE(B11:AF12,"I","")))
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4