Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.12 seconds.

  1. Replies
    6
    Views
    76

    Russco, I don't know your level of expertise...

    Russco,

    I don't know your level of expertise but here is a way to get what you want. I'm sure we can help if you can't do it yourself.


    Use the Dir command to route your filenames to a file....
  2. Maud, Nice piece of code but unfortunately the...

    Maud,

    Nice piece of code but unfortunately the Mouse events are Methods of the Textbox class short of putting a textbox at the top of each column I don't see how to use it to accomplish the OP's...
  3. Calvin, I can't find an event to accomplish...

    Calvin,

    I can't find an event to accomplish that in either the Workbook or Sheet models. HTH :cheers:
  4. Replies
    0
    Views
    26

    File Explorer

    Hey Y'all,

    I just did a Bare Metal install of Win 10 TP on my laptop (Upgrade install from W7 failed!). After updating to 10061 from the 10041 install I started to set it up like my desktop. While...
  5. Replies
    14
    Views
    228

    Lou, OK this will handle either case: ...

    Lou,

    OK this will handle either case:



    Option Explicit

    Function Get_Summary(zShtName As String, zRangeName As String) As Double
  6. Replies
    4
    Views
    89

    Jerry, Although I've experienced CCleaner...

    Jerry,

    Although I've experienced CCleaner doing this and have since changed my settings so it won't do it I did not run CCleaner in this instance.

    What I was doing was Testing out Maudibe's...
  7. Replies
    14
    Views
    228

    Lou, Yes the IFERROR function was new in...

    Lou,

    Yes the IFERROR function was new in XL2007!

    Here's a UDF (User Defined Function) that will do the trick either place:



    Option Explicit
  8. Replies
    4
    Views
    89

    BB, Tried it but didn't work. Probably since...

    BB,

    Tried it but didn't work. Probably since I's started to rebuild it. I'll give that a try immediately if it happens again. Thanks for the reply. :cheers:
  9. Danger, Will Robinson, Danger! 42840

    Danger, Will Robinson, Danger!
    42840
  10. Replies
    12
    Views
    291

    As I was adding Maud's code to said bag it...

    As I was adding Maud's code to said bag it occurred to me what if there were more than one sheet to protect so I decided to build on Maud's fine code once again, he always gives me so many Ideas!

    ...
  11. Maud, Thanks for picking up the "Heavy...

    Maud,

    Thanks for picking up the "Heavy Lifting"! :cheers:
  12. Replies
    4
    Views
    89

    Jump List Disappeared!

    Hey Y'all,

    I just had an interesting thing happen. I was testing some Excel code and needed to save it to a Non-Trusted Location. I did this and it saved fine. However, when I went back to open...
  13. Replies
    12
    Views
    291

    Maud, My comment about "reauthorization"...

    Maud,

    My comment about "reauthorization" wasn't aimed at your button but rather my method of authorization. :cheers:
  14. Replies
    14
    Views
    228

    Lou, No problem:...

    Lou,

    No problem: =IFERROR(INDIRECT($A2&"!TotalSales"),0)

    Just make sure that ALL the references to the same name have Worksheet SCOPE and you don't have one with Workbook Scope!

    42827

    HTH...
  15. Replies
    12
    Views
    291

    Maud, Very nice trick hiding the main sheet to...

    Maud,

    Very nice trick hiding the main sheet to detect if macros are enabled! :thewave:
    You can bet this one is going into my bag of tricks!

    If I might make a suggestion to simplify the...
  16. Replies
    12
    Views
    291

    Maud, I'd love to look at your code but no PW?...

    Maud,

    I'd love to look at your code but no PW? :lol: :cheers:
  17. Caesar, Why not just build a form right in...

    Caesar,

    Why not just build a form right in Excel to collect the data and place it in the database. You can easily have a "Report Sheet" in Excel that will print out what you want from the Selected...
  18. Newbie, Glad to help. Just post back with any...

    Newbie,

    Glad to help. Just post back with any questions. :cheers:
  19. Replies
    14
    Views
    228

    Lou, My post #2 should do what you want with a...

    Lou,

    My post #2 should do what you want with a minor change visa-vie your post #5.

    B2: =IFERROR(INDIRECT($A2&"!B17"),0) {Replacing B17 with the appropriate cell in your detail sheets.}

    Once...
  20. Replies
    3
    Views
    121

    Derfacnauck If the switch has an open port...

    Derfacnauck

    If the switch has an open port hook up the NAS there. This assumes the switch is a GB switch and not 100Mb. You could also buy a GB switch and attach it to one of the modem ports. I...
  21. Newbie, Ok, here's a modification that will...

    Newbie,

    Ok, here's a modification that will return the number of consecutive repetitions of a number equal to or over a specified threshold.




    Function iCountReptDigit(zSearchStr As String,...
  22. Zeddy, No problemo, just though I'd give a...

    Zeddy,

    No problemo, just though I'd give a friendly little jab. I've been known to do exactly the same thing! :lol: :cheers:
  23. Replies
    2
    Views
    63

    [SOLVED] Jaggi, I think I'd just do 3 Search &...

    Jaggi,

    I think I'd just do 3 Search & Replaces,

    1. replace , with ?
    2. replace . with ,
    3. replace ? with .

    HTH :cheers:
  24. Zeddy, I believe that's what I did in post #3....

    Zeddy,

    I believe that's what I did in post #3. :lol:
  25. Replies
    14
    Views
    228

    Lou, I don't know what your data or summary...

    Lou,

    I don't know what your data or summary sheet look like but here's one possibility:
    =IFERROR(INDIRECT("WK"&$A2&"!B17"),0)
    42789

    As always sample workbooks go a long way to getting it...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4