Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.88 seconds.

  1. Replies
    3
    Views
    54

    Re: fill a range with numbers - vba

    Or perhaps one dialog box and no loop.


    Dim RangeToFill As Range

    On Error Resume Next
    Set RangeToFill = Application.InputBox("Select a range to fill with the mouse", Type:=8)
    On Error Goto 0...
  2. Re: Referencing controls on a userform that was created dynamically

    I wonder about the use of the term "dynamically created". In the code posted, you are creating using the Developer object. This does not create a run-time control (that stops existing when the...
  3. Replies
    1
    Views
    49

    Re: range.interior.color - value

    Those are the limits of the values for a cell's colors



    ActiveCell.Interior.Color = RGB(255,255,255)
  4. Re: MS Excel for Mac 2011 - VB Ver 14.0 - Escape Key capture

    Have you tried writing to the QueryClose event to see if you can capture the user exiting the wrong way?
  5. Replies
    3
    Views
    122

    Re: count if doubling results

    =countif(w251:w273,"*o*")+countif(w251:w273,"*+*")-countif(w251:w273, "*o*+*")-countif(w251:w273, "*+*o*")
  6. Re: What's the most efficient way to remove all the salary info from my model without ruining all the calcs?

    You can color the cells, but if the user selects that cell the values are apparent in the Edit window.

    My thought are that if you are confident about creating a "black out the salary cells" macro...
  7. Re: Add #, ignore text, in specific cells (not columns) plus percentages

    Can you post an example of some sample data and the desired result.
  8. Re: For Each Visible cell in range, get me the left 6 characters

    I'm glad you got it sorted out. But I noticed something new.

    You don't need to test for the length. Since Left will take the leftmost characters UP TILL the second argument (i.e. Left("abc",6) =...
  9. Replies
    4
    Views
    98

    Re: Average of an Average

    Taking the average of averages gives you a garbage number.

    To take the grand average, you need to divide the grand total sum by the grand total count.
  10. Re: For Each Visible cell in range, get me the left 6 characters

    ActiveCell is a property of the worksheet, that won't change.

    You should be using cl, the variable that your code has looping through the range of visible cells.

    Instead of cl.Address, you...
  11. Re: For Each Visible cell in range, get me the left 6 characters

    That is because the ActiveCell is the same in every loop.

    Try putting

    cl.Offset(0, 22).Value = "Donk" inside the loop
  12. Re: For Each Visible cell in range, get me the left 6 characters

    I've found that, when looping through ranges, its best to specify what you are looping through


    For Each cl In visrng.SpecialCells(xlCellTypeVisible).Cells(as opposed to .Row, .Columns. or...
  13. Re: EXCEL shapes.visible won't work anymore

    Thank you. I'm glad that you got it sorted out.
  14. Re: Array Formula Question - Condition An Array by Itself

    The CSE formula =MAX(SUMIF(A1:A5,A1:A5,B1:B5)) will give you the max of Test1 total, Test2 total, Test3 total.

    To convert that Test1, Test2, or Test 3
    =INDEX(A1:A5, ...
  15. Re: Add #, ignore text, in specific cells (not columns) plus percentages

    What do you want the result to be if these are the entries

    12
    AT-14
    Sam_23at57
    87
  16. Re: EXCEL shapes.visible won't work anymore

    Have you tried putting Application.ScreenUpdating=True immediately after that line.


    Also, it is possible for different shapes to have the same name on the same sheet. Does...
  17. Replies
    7
    Views
    148

    Re: Mimicking ROW() function using VBA

    Regarding MyRow. It is keyed with the Selection, which is odd. If you want the UDF to refer to the cell holding the formula, you could use Application.Caller


    Function MyRow2(optional aRange as...
  18. Re: Macro to add 1 to 4th then 5th cell for 200 numbers

    I'm glad it worked for you.
  19. Re: Macro to add 1 to 4th then 5th cell for 200 numbers

    Try



    Dim myNumber as Double, rowNum As Long

    With Range("CD:CD")
    MyNumber = .Cells(31,1).Value

    RowNumber = 35
  20. Re: Creating dynamic reference from another workbook

    My guess is that if you move the client_list file, it will have to be when both the workbooks are open.

    As to VBA, I don't think that that will let you move files about. How is the VBA code to...
  21. Replies
    13
    Views
    1,289

    Re: New computer, new Office

    hmm... Perhaps I should have told Apple what to do with USB-C. Thanks.
  22. Replies
    13
    Views
    1,289

    Re: New computer, new Office

    I've seen online third parties offering 2016 and even 2011 for download. Is 2016 for Mac a thing? I like the windows 2016 I have at work.
  23. Re: Creating dynamic reference from another workbook

    Define a dynamic named range for that list, perhaps

    Name: myList
    RefersTo: [Book2]Sheet1!$A2: INDEX([Book2]Sheet1!$A:$A, COUNTA([Book2]Sheet1!$A:$A, 1)


    create this in Book1 (the book with...
  24. Replies
    13
    Views
    1,289

    Re: New computer, new Office

    Grrrr. I hope that it will support existing userforms. Other wise .... I got a problem.


    Thanks for all the info.
  25. Replies
    13
    Views
    1,289

    Re: New computer, new Office

    By create userforms, do you mean at run-time or design time?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4