Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds; generated 41 minute(s) ago.

  1. Sanju, Although it may not be the solution and...

    Sanju,

    Although it may not be the solution and a long shot, I would first try the most obvious and change the destination to an unused location or another sheet in the line:

    from
    ...
  2. Rathril, I was puzzled why you would be...

    Rathril,

    I was puzzled why you would be working tomorrow then I realized that Thankgiving Day is strictly an American holiday and not celebrated by the Brits...duh!

    I continued to do some more...
  3. Replies
    13
    Views
    361

    Ah, yes....thanks for the clarification Maud

    Ah, yes....thanks for the clarification

    Maud
  4. That would be a plus. I guess the first place to...

    That would be a plus. I guess the first place to start would be with the forum moderator. Hopefully RG ("Request Grantor") may be able to help!
  5. Rathril, On your form, I would swap out the...

    Rathril,

    On your form, I would swap out the cboAgent comboboxes for textboxes. The following code will populate the textboxes according to which contact you choose. Your code can be greatly...
  6. Rathril, I started working on this prior to...

    Rathril,

    I started working on this prior to you posting your sample but I think the same principle applies. By selecting the shift at the top, the time start/stop pickers adjacent to the right...
  7. It would be helpful to also know what version...

    It would be helpful to also know what version Excel you are using
  8. Zeddy, You are absolutely correct. Since I...

    Zeddy,

    You are absolutely correct. Since I did not know what version Damien has, I left it in .xls format. Even ,xlsx would have been smaller. To remove the quotes would reduce it even more as...
  9. Replies
    13
    Views
    361

    Reiterating RG's Words of Wisdom, "Remember to...

    Reiterating RG's Words of Wisdom, "Remember to ALWAYS test on a COPY of your workbook!"
  10. Replies
    13
    Views
    361

    Aletrnately, this would achieve the same result....

    Aletrnately, this would achieve the same result.



    Public Sub ExtToValue()
    Dim cell As Range
    For Each cell In ActiveSheet.UsedRange
    If InStr(1, cell.Formula, "[", 1) > 0 Then cell.Formula...
  11. Replies
    7
    Views
    146

    0r =SUM(L2*N2,M2*N2)

    0r =SUM(L2*N2,M2*N2)
  12. Replies
    7
    Views
    146

    Alternately, iIn H2 enter the formula...

    Alternately, iIn H2 enter the formula =IF(L2="",M2*N2,L2*N2) then copy down

    40453

    HTH,
    Maud
  13. Replies
    13
    Views
    361

    jlkirk, "I have a file with > 50 external...

    jlkirk,

    "I have a file with > 50 external links": What format is the file (Word, Excel, txt)? Can we assume that these are URL addresses or data links?

    "What I would like to do is print all of...
  14. Replies
    6
    Views
    151

    Rich, I didn't think you were arguing :) It...

    Rich,

    I didn't think you were arguing :) It was just an FYI as I wasn't sure if you knew where/how your macros were being recorded. Very glad I was able to help.

    Maud
  15. Damien, Here is your properly formatted list...

    Damien,

    Here is your properly formatted list of songs/artists/year/etc.

    40446

    Since it is 1.9Mb, it is too large to upload (18961 songs), I placed it in a zipped file.

    HTH,
    Maud
  16. Replies
    6
    Views
    151

    Rich, If you were to record a macro, you would...

    Rich,

    If you were to record a macro, you would find the actions you took converted to code and located in a module in the VB editor by pressing Alt-F11.
  17. Replies
    23
    Views
    988

    How could I possibly step on my shoe laces when I...

    How could I possibly step on my shoe laces when I purposely tie them so they are well off the ground?
  18. Replies
    45
    Views
    1,225

    Whereas the above formulas provided a blank final...

    Whereas the above formulas provided a blank final grade if all the grades were not entered, if you aboslutely needed an intermediary average for the final grade, a more appropriate way would seem to...
  19. Replies
    45
    Views
    1,225

    Jon5, You are obviously struggling with this...

    Jon5,

    You are obviously struggling with this project. Sometimes best to take a step back. I have readjusted the formulas and codes to compensate for grades left blank in both the final grades...
  20. Replies
    17
    Views
    808

    Scubajay, I think I may have found the way to...

    Scubajay,

    I think I may have found the way to circumvent the issue with the different scales. You can create a second scale on the right side of the graph and assign which data series uses it. ...
  21. I believe the BeforeClose event is not necessary...

    I believe the BeforeClose event is not necessary as the Before save will always clear the cells before closing unless of course you do not want to save (which they will then be cleared on closing). ...
  22. Mohan, Place this code in the ThisWorkbook...

    Mohan,

    Place this code in the ThisWorkbook Module. Change the cells to which ever you want cleared. You can have as many as you want. You could also apply a named range instead (ex, Scores is...
  23. Replies
    3
    Views
    108

    Jim, Instead of double clicking on the second...

    Jim,

    Instead of double clicking on the second file which opens it in the same instance of Excel as the first, open a new instance of Excel then open the file from either File > Open or from the...
  24. Damien, No apologies needed. We all start...

    Damien,

    No apologies needed. We all start somewhere

    1. Open Excel and press Alt-F11 to bring up VBA interface

    2. Insert (on Menu) > Module

    3. Directly under General, paste code as...
  25. Damien, You could also approach this with a...

    Damien,

    You could also approach this with a UDF (User Defined Function). Paste the following code in a standard module. in cell B1, place the following code =Strip(A1) and copy down.

    HTH,...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4