Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Thread: Unknown Files

    by Maudibe
    Replies
    12
    Views
    586

    Alexandra, An after thought.... If you...

    Alexandra,

    An after thought....

    If you convert your files first to .tiff extension and follow your method using icons to filter out what is not a TIFF file, you can reduce the number of files...
  2. Terry, Take a look here. Several with the...

    Terry,

    Take a look here. Several with the same issue found a resolution here:
    ...
  3. Thread: Unknown Files

    by Maudibe
    Replies
    12
    Views
    586

    Alexandra, Look at your PDF column for the...

    Alexandra,

    Look at your PDF column for the last listed type as PDF. Let's say you stopped at line 3000 the you simply change the code line in blue.



    Sub CheckPDF()
    On Error Resume Next...
  4. Thread: Excel Films

    by Maudibe
    Replies
    10
    Views
    231

    A simple exceloogle search!

    A simple exceloogle search!
  5. Thread: Excel Films

    by Maudibe
    Replies
    10
    Views
    231

    My most favorite X-cel film 44740

    My most favorite X-cel film

    44740
  6. Thread: Excel Films

    by Maudibe
    Replies
    10
    Views
    231

    My favorites: Exceltar Excelgeddon The Last...

    My favorites:

    Exceltar
    Excelgeddon
    The Last of the Excelhicons
  7. Meleia, Almost there. One question: From your...

    Meleia,

    Almost there. One question: From your file in post #19, I no longer see where you are applying the markup based on the site type.

    Zeddy

    I am thinking that with the complexity of the...
  8. Replies
    24
    Views
    997

    dpollock, It's a hidden folder. Go control...

    dpollock,

    It's a hidden folder. Go control panel > Folders Options (easy to find if using small icons) > view tab

    1. Tick the option button to show hidden files, folders, and drives
    2, ...
  9. Replies
    4
    Views
    263

    RG, Forgot to mention that in my code, there...

    RG,

    Forgot to mention that in my code, there is a named range called "Ref" that everything references.

    Dubdub,

    I agree with RG that if you moved your criteria/month table to another work...
  10. Meleia, Any reason why some businesses, site...

    Meleia,

    Any reason why some businesses, site types, and site names/numbers are blank? Would they normally be filled?

    Maud
  11. [SOLVED] If you end up beating your head on the wall with...

    If you end up beating your head on the wall with this one and all else fails, you can try a system restore to a point prior to when the issue started. Many times updates or installs can change...
  12. Replies
    4
    Views
    263

    dubdub, You can use this UDF to count your...

    dubdub,

    You can use this UDF to count your matches.

    In cell B20, enter this formula then copy down and to the right:

    =DTcriteria($A20)

    In a standard module, paste the following code:
  13. Replies
    1
    Views
    115

    Without opening a macro file from someone who is...

    Without opening a macro file from someone who is new to the forum, I am taking a shear guess on what you are trying to achieve. The following code will find the max value of from a list of values...
  14. Replies
    4
    Views
    234

    Donebb, If your values are in a column and you...

    Donebb,

    If your values are in a column and you can run vba then this code will convert all the values to the Time formula:

    Place in a standard module:


    Public Sub CvrtTime()
    startcell = 1...
  15. Replies
    6
    Views
    254

    Ferenc, Thanks for the explanation. Adapting...

    Ferenc,

    Thanks for the explanation. Adapting RG's code to a function, here may be one solution:



    Public Sub dsdf()
    iBuyDate = shtStock.Cells(r, "H")
    shtSold.Cells(zDestRow, "K") =...
  16. Absolutely! Can I assume that the rows will...

    Absolutely! Can I assume that the rows will always be grouped by site business in column A but not necessarily sorted?

    I will need some time to make the adjustments.

    Maud
  17. Replies
    6
    Views
    254

    Then your code line would make no sense either. ...

    Then your code line would make no sense either. Just following what you posted and what you asked.

    Maud
  18. Replies
    15
    Views
    8,365

    mrpasawai, It will work if you built your...

    mrpasawai,

    It will work if you built your signature into the body of your email instead of trying to attach it. Use something like


    .HTMLBody = "Hello," & "<br />" & _
    message & "<br...
  19. Replies
    6
    Views
    254

    Ferenc, If RG's solution does not work, try...

    Ferenc,

    If RG's solution does not work, try changing your code line to:

    shtSold.Cells(zDestRow, "K") = #07/06/2015#

    then change the cell format to custom dd/mm/yyyy

    HTH,
    Maud
  20. Replies
    4
    Views
    234

    Donebb, Instead of entering 1:04:55, try...

    Donebb,

    Instead of entering 1:04:55, try entering your elapsed time as =TIME(1,4,55) then sum them all up.

    HTH,
    Maud

    44690
  21. Thread: Date and Time

    by Maudibe
    Replies
    10
    Views
    307

    And of course, the vba approach with a UDF. It...

    And of course, the vba approach with a UDF. It doesn't matter what format column A is.

    Enter the following formulas:

    Cell F1: =DateF(A1)
    Cell G1: =TimeF(A1)

    Then copy down

    In a standard...
  22. Billy, Here is a User Defined Function that...

    Billy,

    Here is a User Defined Function that will sum the weighted "Yes(s)" while filtering out the "No(s)". In cell I7, enter the following formula:

    =SumWt(B7:G7)

    In a standard module,...
  23. Meleia, I did not see you questions in post#9,...

    Meleia,

    I did not see you questions in post#9, apologies! The following revision addresses them.

    1. Clicking on the Markup Button will open a form and allow you to add or remove up to 10...
  24. Hi Meleia, I have adjusted the code to allow...

    Hi Meleia,

    I have adjusted the code to allow you to insert unlimited additional sites. As long as you keep you totals row at the bottom the code will adjust to accommodate the inserted rows. No...
  25. reghyh, The following code will copy each...

    reghyh,

    The following code will copy each sheet of the main workbook only if the sheet's name contains "upload" (case insensitive) to a CSV file with the same name. Please change the path to your...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4