Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    2
    Views
    24

    SkiPro, How about:...

    SkiPro,

    How about: =INDEX(A1:A3,MATCH(MAX(F1:F3),F1:F3,0),1)
    39472
    HTH :cheers:
  2. Replies
    8
    Views
    157

    It's baaaack! Well I installed KB2993651...

    It's baaaack!

    Well I installed KB2993651 yesterday and all seemed OK. That was of course until I booted this morning and my Ad-ins tab was once again missing from all of my Excel workbooks....
  3. Modia, To get rid of the compile error you...

    Modia,

    To get rid of the compile error you need to set a reference to Excel:
    In the VBE window:
    Tools -> References
    39464
    HTH :cheers:
  4. Replies
    2
    Views
    38

    Gavin, You are not using VB but rather VBA...

    Gavin,

    You are not using VB but rather VBA (Visual Basic for Applications). VBA consists of two parts the control language (common to all applications, e.g. Access, Excel, Word, etc.) and the...
  5. Replies
    3
    Views
    49

    Gavin, It does go with the form! 39455 HTH...

    Gavin,

    It does go with the form!
    39455
    HTH :cheers:
  6. Replies
    3
    Views
    76

    E.L., Revo Pro allows you to monitor...

    E.L.,

    Revo Pro allows you to monitor installations which makes for a cleaner uninstall. IMHO it's well worth the $15! I run Pro on all 4 of my machines.
    HTH :cheers:
  7. Replies
    4
    Views
    71

    Les, Use the Tab key to move from item to...

    Les,

    Use the Tab key to move from item to item.

    Space bar will check/uncheck checkbox items.

    HTH :cheers:
  8. [SOLVED] KritzX, Here's the entire Exported Registry...

    KritzX,

    Here's the entire Exported Registry Key:


    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced]...
  9. [SOLVED] KritzX, Ok, here are the two files: 39441...

    KritzX,

    Ok, here are the two files:
    39441
    UnZip them to a directory.
    Right Click on the one you want to use.
    Select Open With Registry Editor
    39442
    Answer YES to the UAC prompt.
    Answer YES...
  10. Replies
    3
    Views
    49

    Gavin, Use an Event Procedure it's much...

    Gavin,

    Use an Event Procedure it's much easier.


    Private Sub Location_AfterUpdate()
    [Location] = UCase([Location])
    End Sub

    Just select Event Procedure instead of Expression Builder and...
  11. Replies
    5
    Views
    111

    Hey Y'all, Here's a helpful article:...

    Hey Y'all,

    Here's a helpful article: Win8Fourms

    Note: the Scheduled task on my machine uses the command: %windir%\system32\defrag.exe -c -h -o -$

    I'm wondering what the -$ is for?

    Don't...
  12. Replies
    9
    Views
    774

    Jean, This will check all sheets: Option...

    Jean,

    This will check all sheets:


    Option Explicit

    Private Sub Workbook_BeforeClose(Cancel As Boolean)

    Dim shp As Shape
  13. Replies
    9
    Views
    774

    Jean, I got to thinking and here's a better...

    Jean,

    I got to thinking and here's a better version. The following code is placed in the This Workbook module.


    Option Explicit

    Private Sub Workbook_BeforeClose(Cancel As Boolean)

    Dim...
  14. [SOLVED] KritzX, Here are 3 solutions...

    KritzX,

    Here are 3 solutions to the extensions situation.

    If you know Powershell here's some help. If you don't post back and I'll give it a shot when I get some time I'm off to a BBQ.

    HTH...
  15. Stephie, Welcome to the Lounge as a new...

    Stephie,

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

    The gold frame is the currently applied style. If you have attached the template but have not applied the style to the currently...
  16. Replies
    9
    Views
    774

    Jean, Did you add the "textboxes" via the...

    Jean,

    Did you add the "textboxes" via the Insert tab or Drawing toolbar? If so they are not really Textboxes but rather Shapes. Unfortunately Shapes do not have events like Exit AFAICT. You can...
  17. Howard, Don't know what is going on at your...

    Howard,

    Don't know what is going on at your machine but it works perfectly on mine.
    I placed the .xlsm file in "G:\BEKDocs\Excel\Test" and
    the .xls file in "G:\BEKDocs\Excel\Test\Pull"
    changed...
  18. Howard, You didn't uncomment the...

    Howard,

    You didn't uncomment the Sheets("Workspace").Select line. Are your file names there?
    Did you check the file in the error message to make sure it was in the Pull directory? Any extra...
  19. JC, IMHO Not something I'd recommend. :cheers:

    JC,

    IMHO Not something I'd recommend. :cheers:
  20. Replies
    11
    Views
    219

    Spark, It's on the Other Tasks Menu. Here's...

    Spark,

    It's on the Other Tasks Menu.

    Here's a tutorial on How-to-Geeks.

    Sorry, I no longer have the Free version as I use the Pro version (well worth the money) which has an auto-verify...
  21. Howard, Minor changes but it works on my Excel...

    Howard,

    Minor changes but it works on my Excel 2010.


    Option Explicit

    Sub Open_Files()

    'Sheets("Workspace").Select 'Uncomment if not using current sheet
  22. Vic, I've had good luck with Samsung Kies...

    Vic,

    I've had good luck with Samsung Kies software. HTH :cheers:
  23. Lamore, Here's your problem, each Report uses...

    Lamore,

    Here's your problem, each Report uses the same sub-reports. So if you change the queries they are based on it doesn't matter which report you open it will be based on the same data. Thus,...
  24. Replies
    330
    Views
    60,688

    RWilkes, 39418 HTH :cheers:

    RWilkes,

    39418

    HTH :cheers:
  25. Replies
    11
    Views
    219

    Spark, Run the Verify process from within the...

    Spark,

    Run the Verify process from within the Macrium Software don't try to run it as a standalone. HTH :cheers:
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4