• 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

    Retrieve one numerical value in a row spanning multiple columns [SOLVED]

    If I understand your question enter this formula on Sheet2 A1 and drag to copy it to the right and it will compare the cells in Sheet1 and show the Value or a "-" if it is not a number. Let me know if this is what you are needing or if you need more than that...
  2. S

    Copy Range, Paste as pic to Word, repeat and paste to the same Word doc.

    Thanks SirJ, I'll give it a read. I may have found a solution after meeting with a friend of mine for an hour. The For Loops are just there to pick the correct cells in the Dashboard to display the next possible Chart. --------------------------- Sub ExportToWord() Dim wrdApp As...
  3. S

    Copy Range, Paste as pic to Word, repeat and paste to the same Word doc.

    Hello All, First post here so please be kind. Do you know the best way in Excel VBA to Copy a range, Open Word, Paste it as a Picture and then, change the dashboard to show a different chart(because my file is a dashboard similar to Chandoo's "Interactive Chart" using pick lists), copy that...
Back
Top