• 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.

Search results

  1. S

    VBA How to autofit image [SOLVED]

    thanks, but i cant seem to find the edit thread anymore. maybe there is a time limitation
  2. S

    VBA How to autofit image [SOLVED]

    Thanks vletm and Marc. I have not write the code yet as of tuesday because I am still looking for solution that needed the least code length. Anyway, I decided to make the background square (n x n size) and then i look for the bigger number between the length and width. Then I resize the bigger...
  3. S

    VBA How to autofit image [SOLVED]

    Dear All I am trying to insert random image and resize it to match the picture place holder (just a square as background). I just want to make sure the image size is smaller than the picture background but still maintain the original aspect ratio, how do i approach this problem? I hope i make...
  4. S

    Excel Web App Interactive in Embedded workbook

    == SOLVED === just allow_interactivity = true Dear All Has anyone try interactive embedded workbook and succeded? I try using slicer yesterday, uploaded it and embed it on a small html file (in my drive) and it works. I dont know how but it works but now it does not work anymore. Looking...
  5. S

    Symbol in Chart Axis

    Thanks Hui, it works now...
  6. S

    Symbol in Chart Axis

    So, I just read http://chandoo.org/wp/2008/08/21/display-symbols-excel-chart/#comment-1192230 and try to copy the example but I cannot get webdings or windings to works. Only font with subsets. Any ideas how/why? Thanks in advance.
  7. S

    Chart Suggestions for Showing Positions from Survey

    This may not be what you need, but this is what came to mind. I change the bussiness into modul A to J instead of 1 to 20 and its interactive, you can view the modul that you want (ex, only your bussiness/modul) Hope it helps.
  8. S

    How to make Graph in Horizontal & Vertical Axis

    Is this it? no macro, just change the value
  9. S

    How to make Graph in Horizontal & Vertical Axis

    Hi Rush, I would like to help but the thing is, i still don't understand your data and what you are trying to to do. Does question 1 and 2 are a pair? so does 3 and 4 and so on.... I attached a macro file which you can changed the intersection manually without going through axis format..
  10. S

    How to make Graph in Horizontal & Vertical Axis

    rush, are you trying to make a quadrant analysist..... Please look at the attachment... Btw, you need to adjust where the axis crossed manually.... if you have more than 1 graph, i suggest record a macro and modify it to your need.. Best wished
  11. S

    dynamic chart using named range in excel 2013

    thanks Misra and Hui... I solved it but I don't know how to edit the title. And Hui, thanks, it looks clean. [more knowledge for me - very nicely done Hui but I think it still has a flaw, the end date will not match with the requirement - the data in the end date will be over then requested]
  12. S

    dynamic chart using named range in excel 2013

    [SOLVED] did not put full workbook right and I do not know how to edit the title ^^ Dear all, I tried to recreate a dynamic chart using named range in excel 2013. I've download the file from chandoo.org and been searching for quite some time for what I did wrong to no avail. I attached sample...
  13. S

    Nearest greedy

    Hi Narayank, Just wondering, do you use shortest path algorithm from A to B or just basically look for nearest position from A (as long as it is not B), then look for another nearest position and so on. I always find path finding algorithm interesting.
  14. S

    Application does not close

    Email sent. I run it again before I email it, and it is still the same. I give link to both macro so that you can notice the difference. Thanks
  15. S

    Application does not close

    I cannot upload the file in public but I can email it to you.
  16. S

    Application does not close

    Yes, that is exactly my point. I have tried to use break point on oPA.Quit and press F8, but does not seem to do anything and there isn't any error message as well. When i look at the powerpoint before oPA.Quit, there are no file open. Just an empty powerpoint app.
  17. S

    Application does not close

    the sub module KopiPie, KopiTabel1,... only add new slide, copy some chart/shape and then return back to main module What is not working is that, the powerpoint app is not closing whereas in the second code it is closing (i did not see powerpoint still open when the code has finished). I hope i...
  18. S

    Application does not close

    Option Explicit Dim sht As Variant Dim oPA As PowerPoint.Application Dim oPP As PowerPoint.Presentation Dim oPS As PowerPoint.Slide Dim sr As PowerPoint.ShapeRange Dim oShape As PowerPoint.Shape Dim NamaProv, NamaKab As String Dim NmFile, cnt, i, JudulSlide, j, k Dim AwalKab, AkhirKab Dim...
  19. S

    Application does not close

    Hi all, I am trying to copy chart/shape from excel to powerpoint and save it as different files based on region. It is working fine, but somehow when I save it as a single file, the powerpoint app close, while in different files it is not. Here is the sample code that does not working Set oPS...
  20. S

    [OT] Forward Sent Items

    Dear All, Pardon for asking [out topic] outlook question here but perhaps someone been using outlook vba and can shed some light. I've been searching through the internet and still could not find the answer for my question regarding outlook. I plan to have an email base information server where...
  21. S

    SUMIF - Alternate Columns

    DebraJ: Sorry, my internet is having problem. I mean I link to cells such as K1 - K5 which consist all the criteria Narayan : Thank you for the quick reply. I try to understand it first. Any idea on non array formula? My original data consist more than 100k record. I tried to avoid array...
  22. S

    SUMIF - Alternate Columns

    Narayan: Is it possible to use non adjacent column with your formula? Because that is what I wanted to do. DebraJ : How do you add Blank to data validation list -- Nervermind... I just use cells for this... Thanks
  23. S

    SUMIF - Alternate Columns

    Thanks alot Narayan. Can you explain why it failed to work before? Btw, I still dont understand why it works Why I cannot use ...
  24. S

    SUMIF - Alternate Columns

    Dear all I am looking for (non array formula) alternative solution to sumif problem. I edited two solutions from my previous problem and so far only array formula that works. Any idea on what went wrong? I attached the sample workboook Thanks in advance
Top