Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Matt, You had 2 hidden columns (B and AH) that...

    Matt,

    You had 2 hidden columns (B and AH) that I did not account for. The error is fixed and the email reflects the type of service required.

    Maud
  2. Replies
    4
    Views
    64

    This issue has been discussed in the forum many...

    This issue has been discussed in the forum many times. Ruling out any obvious reasons, if I remember correctly, the general consensus was that the spreadsheet was corrupted and the workaround was...
  3. Replies
    13
    Views
    425

    Zeddy, Coming from you, that is a great...

    Zeddy,

    Coming from you, that is a great compliment.

    Thx
  4. Matt, Here is the revised sheet. If the...

    Matt,

    Here is the revised sheet. If the inspection is due within 14 days, a reminder and email will be sent. If the inspection is over due then just an email will be sent. The added comment...
  5. Replies
    1
    Views
    49

    Shoot to survive

    Without searching the Internet....

    Mr. Black, Mr. Gray, and Mr. White are fighting in a truel. They each get a gun and take turns shooting at each other until only one person is left. Mr. Black,...
  6. Replies
    13
    Views
    425

    fjohan, Although labor intensive because of...

    fjohan,

    Although labor intensive because of inconsistent delimiters and columns, it can still be done. In the textbox, enter the complete path of the text file as shown then click the Run Code...
  7. Workingonit, Here is the same code as a...

    Workingonit,

    Here is the same code as a function instead that will take the comments from another sheet based on the value of another cell..



    Public Function AddComment(rng As Range)
    ...
  8. Workingonit, That can easily be done by...

    Workingonit,

    That can easily be done by replacing the comment text in the code with a cell reference to Worksheets("Sheet2").Range("F1").Value and ..."F2).value



    Private Sub...
  9. Replies
    7
    Views
    380

    RG, Nice Tweak!!!

    RG,
    Nice Tweak!!!
  10. Replies
    7
    Views
    380

    Unome, Here is some sample data with a button...

    Unome,

    Here is some sample data with a button that has a caption to sort either ascending or descending. Clicking the button will sort the the data in the direction specified and the button's...
  11. Replies
    10
    Views
    220

    Drizzt, I have emailed you back your revised...

    Drizzt,

    I have emailed you back your revised sheet. It will realign the checkboxes each time the sheet is opened.

    Please note the large number of duplicated unused and non-visible checkboxes...
  12. Ok Matt, Will revise the sheet to your specs ...

    Ok Matt,
    Will revise the sheet to your specs

    Maud
  13. Replies
    12
    Views
    329

    perhaps it is the method that your desk desk...

    perhaps it is the method that your desk desk calculator rounds at each input such as columns G thru I in my example
  14. Replies
    12
    Views
    329

    Staven As Paul and RG have indicated, if you...

    Staven

    As Paul and RG have indicated, if you format B5:D5 to show 2 decimal places, the total remains 100.00 in cell F5. Cells G5:I5 have the rounding function applied and result in 100.01...
  15. Replies
    10
    Views
    220

    You're on top of it Zeddy! We just don't know if...

    You're on top of it Zeddy! We just don't know if the are aligned or staggered on the OP's sheet
  16. Replies
    10
    Views
    220

    Zeddy, The only issue with using that line of...

    Zeddy,

    The only issue with using that line of code is that it lines them all up only if they are already aligned somewhere on the sheet. If they are staggered on the page, then it moves them as a...
  17. Imandel, Using your post example, here is some...

    Imandel,

    Using your post example, here is some code (Example1.xlsm) that will compare columns B and C then place an "X" in column D if they are the same. The code will adjust for any number or...
  18. Replies
    10
    Views
    220

    Until you can correct the issue, here is a...

    Until you can correct the issue, here is a workaround that will shift the boxes to the left when the workbook opens:

    Before code runs:
    41909

    After code runs:
    41910

    In the ThisWorkbook...
  19. Here is the code written as a function if you...

    Here is the code written as a function

    if you want to add a comment in D1 with the contents based on the value in A1 then place the following formula in Cell D1 =AddComment(A1)

    If A1=1 then...
  20. Replies
    6
    Views
    127

    Try sorting your table array in an ascending...

    Try sorting your table array in an ascending order. If it can't be sorted, try the following formula

    In cell O2 =INDEX(I2:L62,MATCH(N2,I2:I62,0),4)

    HTH,
    Maud
  21. Workingonit, The following code placed in the...

    Workingonit,

    The following code placed in the sheet module will add/change a comment in Cell F1 based on the numeric value in cell A1.

    In A1, enter a 1, 2, or delete the contents of the cell...
  22. Replies
    15
    Views
    325

    Now, you wouldn't be insulting our national past...

    Now, you wouldn't be insulting our national past time I hope?
  23. Matty, If you are asking if you can send the...

    Matty,

    If you are asking if you can send the email to more than one person the answer is yes. You can either email the second, third, etc. directly or c.c. them. Your preference. If you create...
  24. Replies
    8
    Views
    183

    Skipro, I think this solves it. The trick is...

    Skipro,

    I think this solves it. The trick is to hold the previous value of the cell. This can be done by writing it to a another cell however, I chose to write it to a textbox on an unused form...
  25. Replies
    8
    Views
    183

    Skipro, Try this in a worksheet module ...

    Skipro,

    Try this in a worksheet module



    Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Cells.Count > 1 Then Exit Sub
    If Not Intersect(Target, Range("N2:N100")) Is...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4