Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    16
    Views
    827

    Kris, Attached is the revised file that will...

    Kris,

    Attached is the revised file that will prevent the user from progressing past the popup message box unless a password has been entered.

    The case sensitive password is "Dirty Toilet"...
  2. Replies
    16
    Views
    827

    Yes, that is possible but which cells are you...

    Yes, that is possible but which cells are you talking about Kris? Are you asking that once they are populated with a holiday, a password is needed to remove the holiday?
  3. Replies
    4
    Views
    229

    Danny, Paul is probably right but if your...

    Danny,

    Paul is probably right but if your situation warrants it, try this:


    Sub CopyFormulas()
    With ActiveSheet
    .Range("J2").Formula = "=IF(C2=10," & """1010""" & ",IF(C2=11," &...
  4. Replies
    5
    Views
    181

    Modified so the year will allways be the current...

    Modified so the year will allways be the current year without having to change it:
    ...
  5. Replies
    5
    Views
    181

    Try:...

    Try:
    =SUMPRODUCT(($E$2:$E$11)*(($C$2:$C11="RED")*($D$2:$D$11="CCA")*(B2:B11>DATE(2015,1,1))*(B2:B11<DATE(2015,6,1))))

    Maud
  6. Replies
    5
    Views
    244

    Yes, move the code to a standard module the...

    Yes, move the code to a standard module the assign a button or just run from macros in developer tab.
  7. Try running Internet Explorer in safe mode. If...

    Try running Internet Explorer in safe mode. If your crashes are resolved then you know it is an add-on, browser helper, or active x that is causing the issue. Start > Search > type "iexplore...
  8. Replies
    14
    Views
    431

    An alternative VBA: Private Sub...

    An alternative VBA:



    Private Sub Worksheet_Change(ByVal Target As Range)
    If IsDate(Target) Then
    Dim wd As String
    Select Case Weekday(Target)
    Case 1:: wd = "Su, "
    Case 2:: wd = "Mo,...
  9. I made some tweaks to RG's nice code to eliminate...

    I made some tweaks to RG's nice code to eliminate some bugs.

    1. Multiple selection causing mismatch error
    2. Leaving the warning message in input box then clicking OK places warning message...
  10. Replies
    6
    Views
    380

    Geof, Since URLs don't have spaces, my guess...

    Geof,

    Since URLs don't have spaces, my guess is that they need to be removed mid string but so should the leading and trailing as you suggest.

    Maud
  11. Replies
    6
    Views
    380

    Geof, Keeping in mind that the Trim function...

    Geof,

    Keeping in mind that the Trim function removes only leading and trailing spaces, to save a few lines of code, you could use:


    Sub testTrim()
    [a1] = Trim([a1])
    End Sub
  12. Replies
    5
    Views
    244

    Hi Trueborn, To answer your questions 1. If...

    Hi Trueborn,

    To answer your questions
    1. If this is my spreadsheet and I want to link the YELLOW highlighted dates to my outlook, so that it automatically sends me a reminder, but I also want it...
  13. Replies
    16
    Views
    827

    Hi Kris, Now that I fully understand what you...

    Hi Kris,

    Now that I fully understand what you want to do, here is the adjusted worksheet.

    HTH,
    Maud
  14. Replies
    16
    Views
    827

    Dummy me. I was thinking that the core areas...

    Dummy me. I was thinking that the core areas were the 20th, 21st, 22nd, etc.... Now it becomes clear. To do what you want, you will need provide a list of all the possible core areas."

    Also,...
  15. Replies
    16
    Views
    827

    I realized that the worksheet change event was...

    I realized that the worksheet change event was occurring prior to the recalculation of columns B and C therefore producing the wrong message as noted above. This has been corrected by moving the...
  16. Sbdale, Not sure why you are using an array...

    Sbdale,

    Not sure why you are using an array formula where

    =INDEX(F3:J367,MATCH(C2,F3:F367,0),5) in cell C3 would provide the same results (208 in this case).

    HTH,
    Maud
  17. Replies
    16
    Views
    827

    Kris, I am not sure how you are grouping Rest...

    Kris,

    I am not sure how you are grouping Rest days but as an example, I put together a spreadsheet that will allow entry of specific types of days off and holidays. I added data validation to...
  18. Replies
    11
    Views
    659

    Shembo, Thanks for the screen shot. Something...

    Shembo,

    Thanks for the screen shot. Something is being sent to the class module that is not correct. I rechecked the file I posted and it runs fine. Let's make sure each of the following is...
  19. Replies
    16
    Views
    827

    Kris, I have expanded the code to encompass...

    Kris,

    I have expanded the code to encompass 500 columns. It has unlimited rows. It will continue to warn if 2 RD's on the same area but it will also give a different warning if there are already...
  20. Replies
    16
    Views
    827

    Kris, Here is your workbook revised. If there...

    Kris,

    Here is your workbook revised. If there are more that 1 RD entered for an area (col B thru E), a warning message box will appear.

    HTH,
    Maud



    Private Sub Worksheet_Change(ByVal...
  21. Replies
    4
    Views
    475

    Perhaps I read too much into the question. From...

    Perhaps I read too much into the question. From David's post, I am now assuming that not all the perfect squares need to have a combination rather that all of the combined numbers must equal any...
  22. Replies
    4
    Views
    475

    Coming up with a different logic and answer. 4...

    Coming up with a different logic and answer.

    4 is a perfect square. Combinations of 4 are: 0+4, 1+3, 2+2. Since 0 is not a possible assigned number and there is only one 2, the only possible...
  23. Howard, Here is your revised file. I used...

    Howard,

    Here is your revised file. I used only the NewZip function provided by Ron de Bruin and rewrote the rest using some code I modified from some source obtained somewhere in the past. The...
  24. Howard, You are getting a compile error...

    Howard,

    You are getting a compile error because it is looking for two functions that do not exist: NewZip() and bIsBookOpen(). Also, your code to get your files should be amended to:


    FName...
  25. Replies
    5
    Views
    432

    Ferenc, Not sure how your solution could...

    Ferenc,

    Not sure how your solution could possibly work. (In blue) You are missing the colon and quotes and also your key should be a column range not the entire range of the sort. You are sure...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4