Search:

Type: Posts; User: Rick Rothstein

Page 1 of 20 1 2 3 4

Search: Search took 0.01 seconds.

  1. A Method To Store Workbook Settings...

    For VBA programmers... how do you store settings specific to your program(s) or other values you wish to preserve between Excel sessions? Probably most of you simply add a new worksheet, place the...
  2. Since you are doing this in VBA, the question of...

    Since you are doing this in VBA, the question of how you convert the text to a number becomes important. Consider these...

    MsgBox Application.IsNumber(Val("OCT1"))

    MsgBox...
  3. Replies
    7
    Views
    32,549

    Sorry for the long delay in answering your...

    Sorry for the long delay in answering your question. Actually, I am not sure I know how to do what you asked for; however, given you are using a Windows' computer, why isn't the date and time...
  4. Replies
    6
    Views
    39,058

    If you want, you can simply place the year number...

    If you want, you can simply place the year number (4 digits) in cell B3 (eliminating the Volatile TODAY function call) and then put this single formula in your first third-Wednesday cell and then...
  5. Replies
    42
    Views
    1,063,194

    Take a look at Message #9... it should give you...

    Take a look at Message #9... it should give you the method needed to assign the points to an array for use in my function.
  6. Replies
    23
    Views
    1,106,820

    I know I am a few years late with this, but here...

    I know I am a few years late with this, but here is a function that with take a delimited text string (which is the output from my ConCat function) and returns the same delimited text with duplicate...
  7. Replies
    3
    Views
    1,741

    *** DUPLICATE POSTING *** ...

    *** DUPLICATE POSTING ***

    https://www.mrexcel.com/forum/excel-questions/1084045-custom-ribbon-how-access-checkbox.html
  8. Replies
    3
    Views
    1,741

    There is probably a direct access via the...

    There is probably a direct access via the Application object or a property of the sheet or range.

    Which checkbox did you want to get the status of?
  9. That is why I use the table tags... I am using...

    That is why I use the table tags... I am using Internet Explorer and there was no way to stop the code lines from wrapping without using the table tags.

    ...
  10. Replies
    42
    Views
    1,063,194

    See the last comment I made in Message #20 for...

    See the last comment I made in Message #20 for the reason why I required the first and last points to be the same.
  11. The argument to the Evaluate function (which is a...

    The argument to the Evaluate function (which is a large percent of the code line) is a text string, so you cannot just insert line continuations within that portion of the code line... rather, you...
  12. If I am not mistaken, this non-looping macro...

    If I am not mistaken, this non-looping macro should also work...



    Sub ThisShouldWork()
    Dim LastRow As Long
    LastRow = Cells(Rows.Count, "A").End(xlUp).Row
    Range("A1:A" & LastRow) =...
  13. If I understand what you want correctly and...

    If I understand what you want correctly and assuming Row 1 contains the headers and your data starts on Row 2, put this formula in cell D2 and copy it down to the end of your data...
    ...
  14. See inline comments in red... Sub...

    See inline comments in red...

    Sub SegmentsDown()
    ' I always declare my variables by name and type
    Dim RowNum As Long, Ar As Range
    ' Starts a loop that looks down Column A and that will...
  15. Here are macros for each of the results you asked...

    Here are macros for each of the results you asked for. The first (SegmentsDown) gives the first results you asked for and the second (SegmentsAcross) gives the second result you asked for...

    Sub...
  16. The following comment is for the red highlighted...

    The following comment is for the red highlighted text, but it also applies (concept-wise) to the blue highlighted text as well. You do not need to use the double Application.Transpose to assign a...
  17. A couple of questions... 1) Are the dates in...

    A couple of questions...

    1) Are the dates in each cell always in sorted order as shown in your picture?

    2) Is the delimiter between the dates a comma by itself or a comma followed by a Line...
  18. You need to keep in mind, though, that the value...

    You need to keep in mind, though, that the value for that cell is NOT what you see in the cell... your value does not physically change, only its display. So if you type 1234 in the cell, you see...
  19. Replies
    42
    Views
    1,063,194

    You did not supply an x1,y1 point that fails to...

    You did not supply an x1,y1 point that fails to work so that I could test it out; however, I am suspicious of your A1 array declaration (probably your A2 array's declaration as well). You have the A1...
  20. Replies
    42
    Views
    1,063,194

    Note... I removed your quote of my entire...

    Note... I removed your quote of my entire original post from your post... no need to burden this forum's servers with duplicate data that does not serve to any real reference purpose in your message....
  21. Replies
    5
    Views
    32,690

    Thank you for registering and taking the time to...

    Thank you for registering and taking the time to offer your thanks for my posting... I am glad you found it useful in some way.
  22. I know it is some two years later, but I am...

    I know it is some two years later, but I am thinking I missed the significance of your tweak back then (or maybe I missed the message altogether, I am no longer sure at this late date); however, I...
  23. It is hard to see that small picture, but if what...

    It is hard to see that small picture, but if what is displayed in the picture is all of the code you copied, then you did not manage to copy all of the code there is.
  24. Replies
    7
    Views
    32,549

    I don't have the 64-bit version of Excel, so I...

    I don't have the 64-bit version of Excel, so I cannot check, but as far as I know, yes, that all you need to do.
  25. Replies
    42
    Views
    1,063,194

    You are talking about aircraft and you are...

    You are talking about aircraft and you are worried about what amounts to infinitesimally small fractions of an inch? I think you are being overly trusting in the supposed accuracy of numerical...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4