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

    XL07 SP2 - Save as PDF - charts not presented correctly

    Hi, Don't if anyone else is having the same problems but there is a bug in SP2 where graphics and charts embedded in a worksheet do not scale to WYSIWYG in PDF. The Hotfix in the link below looks like it might solve the problem. http://support.microsoft.com/kb/973402/en-us
  2. J

    Hiding lines using Excel Tick boxes

    Hi, Not sure if the below is Excel version dependant or not, but.. Right Click on the tick box, select 'Format Control' at the bottom of the mouse menu. In the popup wizard go to the 'Properties' tab and select the 'Move and Size with cells' radio button. I tested this manually [not...
  3. J

    Display filename/tab of a linked spreadsheet

    Hi, Try this Function ExternalLinkAsString(cell As Range, _ Optional default_value As Variant) ExternalLinkAsString = CStr(cell.Range("A1").FormulaLocal) End Function It simply gets the formula of any selected Cell and displays it as a string. To extract pieces of the string to get...
  4. J

    Hello .. Introduce yourself

    Hi, I'm Justin (JB),from New Zealand I was fortunate enough to stumple upon this site about a year ago and have visited every week since. I'm always stunned how visitors and contributors to this site are using Excel and have learnt a great many new ways to use it by following the tips/tricks...
  5. J

    SeePower Visualiser

    Just wondering if anyone is using anything from the Compudigm SeePower suite of apps, & what you think. It's an impressive piece of kit when implemented correctly
Back
Top