Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.10 seconds.

  1. YangYangLi, Here's a possible approach. 1....

    YangYangLi,

    Here's a possible approach.
    1. Setup an Advanced Filter to select Unique Vendor References. Use Range Names for Database, Criteria, & Extract
    39701
    2. Create Dynamic RangeNames for...
  2. Replies
    5
    Views
    121

    Arcturus, Option Explicit Sub TestIB()...

    Arcturus,



    Option Explicit

    Sub TestIB()

    Dim zAns As String
  3. [SOLVED] Balla, Don't know a way to do it in a formula,...

    Balla,

    Don't know a way to do it in a formula, however, you can do it with a User Defined Function (UDF)


    Option Explicit

    Function dblMySumIf(rngCriteriaRng As Range, zCriteria As String,...
  4. Herschm, Google "Route Lpt1 to USB" there are...

    Herschm,

    Google "Route Lpt1 to USB" there are some promising items there. HTH :cheers:
  5. Replies
    3
    Views
    790

    Jim, Offline NT Password & Registry Editor...

    Jim,

    Offline NT Password & Registry Editor.

    Just clear the password then reset it once you're back in Windows. HTH :cheers:
  6. Thread: Clone?

    by RetiredGeek
    Replies
    4
    Views
    176

    Bruce, Right ON! You hit the nail on the head....

    Bruce,

    Right ON! You hit the nail on the head. I didn't think just a new SSD would set it off but it did. I made a quick (automated) call to MS and all is back to normal. :cheers:
  7. Thread: Clone?

    by RetiredGeek
    Replies
    4
    Views
    176

    Jerry, When I try the Reg files it just...

    Jerry,

    When I try the Reg files it just adds/removes the directory where windows is installed, e.g. C:\Windows.

    From what I can see my secure boot UEFI setup is still intact.
    From Belarc...
  8. Thread: Clone?

    by RetiredGeek
    Replies
    4
    Views
    176

    Clone?

    Hey Y'all,

    Here's an interesting development.

    I received my new SanDisk Extreme Pro 240 Gb drive today.
    So hook up the drive via USB 3.0 connector.
    Fire up Macrium Reflect Pro and clone the...
  9. Replies
    9
    Views
    192

    Vee, M5 needs to be written as $M$4 (an...

    Vee,

    M5 needs to be written as $M$4 (an absolute reference) it then will not change as dragged.

    Another way to insure Absolute References is to give it a Range Name.
    Place your cursor on the...
  10. Replies
    9
    Views
    192

    Vee, Welcome to the Lounge as a new poster!...

    Vee,

    Welcome to the Lounge as a new poster! :cheers:

    See if this meets your needs?

    =100-IF($H3<=$M$5,0,(INT(((MINUTE($H3-$M$5)*60)+(SECOND($H3-$M$5)+5))/10)))

    Note 1: The formula is of...
  11. Replies
    2
    Views
    173

    RoboForm Desktop Half Price

    Hey Y'all,

    My Favorite Password Manager is available today at 1/2 price here.

    Disclaimer: I have no connection or financial interest in RoboForm. I'm just a very happy customer. I have RF...
  12. Replies
    14
    Views
    510

    [SOLVED] Sparky, Glad you got it sorted. :cheers:

    Sparky,

    Glad you got it sorted. :cheers:
  13. Replies
    5
    Views
    193

    Fred, I know you said no VBA but JIC: ...

    Fred,

    I know you said no VBA but JIC:


    Option Explicit

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

    '*** Limiting the Worksheet_Change event to a...
  14. Replies
    12
    Views
    211

    [SOLVED] Lou, One observation I made while working with...

    Lou,

    One observation I made while working with your document was that I think you'd be better served not having a section for each song. Rather, create a header style for the song title that...
  15. Wavy, No they email you a key and you can...

    Wavy,

    No they email you a key and you can install any time. HTH :cheers:
  16. Replies
    12
    Views
    211

    [SOLVED] Lou, On the Home page turn on Paragraph Marks...

    Lou,

    On the Home page turn on Paragraph Marks
    Place your cursor immediately to the right of the paragraph mark on the Section Break line. (See red mark below)
    39665
    Hit the Delete Key
    On...
  17. [SOLVED] George, You could also look into a Eye-Fi card...

    George,

    You could also look into a Eye-Fi card. This is a SD memory card with builtin Wi-Fi. I use one to transfer pics from my camera to Kindle for posting on FB while traveling. Works great....
  18. Don, Download the Offline NT Password Reset...

    Don,

    Download the Offline NT Password Reset Disk on another machine and create a bootable CD/USB key.

    Boot from the created media and just follow the prompts and CLEAR the password don't try to...
  19. Replies
    5
    Views
    197

    Alan, Welcome to the Lounge as a new Poster!...

    Alan,

    Welcome to the Lounge as a new Poster! :cheers:

    I'd go ahead and set it up as you most likely be able to upgrade very easily.

    If you don't want to deal with the touch screen you can...
  20. nehaljwani, Welcome to the Lounge as a new...

    nehaljwani,

    Welcome to the Lounge as a new poster! :cheers:

    I would that Step 1 be amended to: Take a full Image Backup of your system first -- DO NOT SKIP THIS STEP!
    Make your Step 1 Step 2....
  21. MNN, See this TechRebuplic Article...

    MNN,

    See this TechRebuplic Article. HTH :Cheers:
  22. Replies
    16
    Views
    1,535

    Paul, I would assume so. 39659 HTH :cheers:

    Paul,

    I would assume so.
    39659
    HTH :cheers:
  23. Replies
    16
    Views
    1,535

    Is IE safe?

    Hey Y'all,

    Here's an interesting experience I had today.

    I was trying to download the NirSoft Utilities (which often throw flags for viruses) using FireFox.
    First try - no go warned of...
  24. Hey Y'all, Just a couple of notes on this. ...

    Hey Y'all,

    Just a couple of notes on this.

    I tried to create the Win PE boot disk and it failed on 2 different USB Keys a 256Mb key (this was too small as the ISO is 374Mb) and a 4GB Cruiser...
  25. Replies
    14
    Views
    241

    [SOLVED] Mike, If you take an Image (see post #4 above)...

    Mike,

    If you take an Image (see post #4 above) of the HDD there is no need to reformat the SSD, which would only use up some of its limited write cycles. HTH :cheers:
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4