Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.13 seconds; generated 3 minute(s) ago.

  1. Replies
    14
    Views
    470

    Rory, Who knew! I rarely use DV as I...

    Rory,

    Who knew!

    I rarely use DV as I usually use VBA for checking. That sure fixed the problem and now the formula works directly in DV.

    Can you elaborate more on why this is so? :cheers:
  2. Replies
    14
    Views
    470

    Hey Y'all, This is crazy! If a cell contains...

    Hey Y'all,

    This is crazy! If a cell contains text it should have a value of zero but obviously this isn't always what Excel calculates it as!

    For instance: =(c5+1)>0 returns #VALUE! when c4...
  3. Replies
    14
    Views
    470

    Fred, Actually, this does work...

    Fred,

    Actually, this does work
    =AND((LEN($S$4)<3),(OR($C$5="out",$C$5>0)))

    HTH :cheers:
  4. Replies
    14
    Views
    470

    Fred, This formula works according to your...

    Fred,

    This formula works according to your specs.
    =AND(ISBLANK(S4),OR(C5="out",C5>0))

    Note: If you change S4 after entering C4 it will NOT re-validate!
    HTH :cheers:
  5. Jerry, Too TRUE! 41935 :cheers:

    Jerry,

    Too TRUE! 41935
    :cheers:
  6. Replies
    7
    Views
    363

    Unome, This line: Set rng = Range("a7:Q999")...

    Unome,

    This line: Set rng = Range("a7:Q999") 'CHANGE TO RANGE OF ENTIRE ARRAY

    Should read: Set rng = Range("Q7:S999") 'CHANGE TO RANGE OF ENTIRE ARRAY

    At least from the workbook that Maud...
  7. Replies
    7
    Views
    363

    Maud & Unome, Nice code Maud! If I may a...

    Maud & Unome,

    Nice code Maud! If I may a slight modification which I think will make the code easier to maintain.

    Button Code (Sheet1 module):


    Option Explicit

    Private Sub...
  8. Replies
    11
    Views
    182

    Verada, Here's another version just to show...

    Verada,

    Here's another version just to show you another way to tackle this type of USER INPUT problem.

    The attached workbook uses a User Input Menu to gather the data vs having the user place...
  9. Replies
    12
    Views
    285

    Slaven, The problem here is you can't expect...

    Slaven,

    The problem here is you can't expect to round numbers to a lesser precision (2 vs 4 decimal places) and then get the same result in a final answer. Intermediate rounding (e.g. each value...
  10. Replies
    8
    Views
    185

    Drizzt, I'd suggest that once you have them...

    Drizzt,

    I'd suggest that once you have them aligned to hold your Shift key and right-click each of them then release the Shift key right-click any one of them and select Group. They will now stay...
  11. Replies
    12
    Views
    285

    Paul, What version of Excel are you using? ...

    Paul,

    What version of Excel are you using?
    Things seem to work fine in 2010
    41921
    :cheers:
  12. Replies
    4
    Views
    195

    Don, As long as you have the Windows KEY for...

    Don,

    As long as you have the Windows KEY for Computer 2 you should be fine. The Key is usually found on a sticker on the machine. You can also use a product like Magic Jelly Bean Finder to extract...
  13. Replies
    12
    Views
    285

    Slaven, There is a thing you MUST remember...

    Slaven,

    There is a thing you MUST remember about Excel, that being formatting a number to 2 decimal only affects how the number is displayed NOT the value of the number used in calculations!
    ...
  14. Paul, Fingers not connected to brain! :lol:

    Paul,

    Fingers not connected to brain! :lol:
  15. Replies
    11
    Views
    182

    Zeddy, Still learning after all these years. ...

    Zeddy,

    Still learning after all these years. Thanks for the excellent code on the use of all the features of the Sheet Protect/UnProtect methods. :cheers:
  16. Looks like you need drivers for your CD/ROM. Go...

    Looks like you need drivers for your CD/ROM. Go to Device Manager and see if you have the Yellow caution triangle on the CD/ROM drive.. Then use the options to reinstall the device driver or go to...
  17. Zeddy, I can't find one. You can find a full...

    Zeddy,

    I can't find one. You can find a full list of codes HERE. HTH :cheers:
  18. Hey Y'all, To prevent the smiley faces from...

    Hey Y'all,

    To prevent the smiley faces from use of the colon enclose the formulas in NOPARSE tags {noparse} formula here {/noparse}
    Just REPLACE the {} with [] for it to work properly.
  19. Replies
    36
    Views
    1,829

    David, If you're waiting for Win10 you might...

    David,

    If you're waiting for Win10 you might also wait for Intel SkyLake processors due out about the same time. When I searched for the link I found an article that says they may be delayed to...
  20. Replies
    8
    Views
    179

    Hey Y'all, It 's the old 90/10 rule. 90% of...

    Hey Y'all,

    It 's the old 90/10 rule. 90% of the requirements require 10% of the time and effort the last 10% of the requirements (often the a fore mentioned extreme testing/error trapping) consume...
  21. Replies
    7
    Views
    138

    Paul, Right...I forgot to mention the RoboCopy...

    Paul,

    Right...I forgot to mention the RoboCopy GUI the article linked also mentions RichCopy which has a GUI. HTH :cheers:
  22. Replies
    7
    Views
    138

    WDH, Is the drive a data ONLY drive? If so,...

    WDH,

    Is the drive a data ONLY drive? If so, you could sync the entire drive if you wish using something like RoboCopy (my personal favorite and free). I have a RoboCopy batch file that is run by a...
  23. Roland, Unfortunately, I remember farther back...

    Roland,

    Unfortunately, I remember farther back then that! :lol: How about VisiCalc & SuperCalc. But that's a story for another thread! :cheers:
  24. Replies
    11
    Views
    182

    Verada, Ok, I've made some minor changes to...

    Verada,

    Ok, I've made some minor changes to the code and I think the Col C thing won't be a problem because:

    If the user clicks anywhere in C the code will automatically move the cursor to the...
  25. Replies
    11
    Views
    182

    Verada, I found an error in the protection...

    Verada,

    I found an error in the protection scheme you need to make the changes in BLUE in the code below located in the Tools module.



    Sub UserProtect()

    ActiveWindow.WindowState =...
Results 1 to 25 of 490
Page 1 of 20 1 2 3 4