• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by TimeWarp

  1. T

    Need to abort source workbook loading after macro finishes

    Luke, Much joy! I thought about the question I just posted and realized that I added the "Application.EnableEvents = False" command right after the sfilename = Application.GetOpenFilename "Workbooks.Open sfilename" protion of my macro. By moving the "Application.EnableEvents = False"...
  2. T

    Need to abort source workbook loading after macro finishes

    Luke, Good idea but no joy. My macro still runs through to the end but I also still get the macro security dialog at the end of the process. Dose the userform that fires upon opening the source workbook also qualify as an event? If so, is there away to target the "Application.EnableEvents =...
  3. T

    Need to abort source workbook loading after macro finishes

    Hi Luke M, Yes, you are correct on all three remarks. There is a worksheet change event tied to each worksheet, there is a form that gets activated when the workbook would normally open and if I allow the workbook to open by allowing macros when the security dialog fires at the end of my...
  4. T

    Need to abort source workbook loading after macro finishes

    Details: I have two workbooks, a source workbook to import ranges of data from and a destination workbook to import the data into. Both workbooks have the same worksheets and userforms, except the destination workbook has improvements. The purpose here is to import log data going back as far...
  5. T

    Match dates without helper column?

    Hi Hui, Actually I want to thank you very much for your "IF(SUMPRODUCT()" statement. Combining that with a "TEXT(the_formula, m/d/yyyy)" function, did the trick for me. I'm not sure if someone else would find my solution useful, but for those like myself whom have quickly come to recognize...
  6. T

    Match dates without helper column?

    Yes, as you stated for the third formula. I also went into formula auditing mode, to confirm the finds of the array, which evaluated to zeros. Any ideas of the cause?
  7. T

    Match dates without helper column?

    Hi Hui, I appreciate what you have done with all three formulas. The first and second formulas both confirm if a first and/or a second date equal the same month selected from the validation drop-down list. Although, I did a poor job of explaining what my ultimate goal is. What is needed is...
  8. T

    Match dates without helper column?

    Hi All, I have a sheet data range of F16:AA28. The range of cells has dates, non-contiguous. The date format used is, "d/m/yyyy". At cell AB15, I have a validation drop-down list to select dates of various months throughout the year. I would like to know of a formula I can use on each row of...
  9. T

    Conditional format with dates.

    Hi Hui, Thank you so much for your response to the hair puller that I posted. I was unable to get "EOMONTH" to work with Conditional Formatting due to the following error message; >"You may not use references to other worksheets or >workbooks for Conditional formating criteria."...
  10. T

    Conditional format with dates.

    Hi All, I have a row of cells numbered 1 thru 22. The sheet range is F15:AA15. Directly below that are a range of cells with dates, non-contiguous. The date format used is, "d/m/yyyy" and the range is F16:AA28. At cell AB15, I have a validation drop-down list to select dates of various...
Back
Top