RE: Creating secondary Y axis in Excel from vbscript w/i a web page

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi

Thanks for your detailed sample.
So far I did not understanding your question very much.
Can you do it with Excel UI?
If so, I think you may try to record the macro to see what it will be done
via macro.
Or you can send me the xls file about what you are going to do via removing
"online" from my email address.
Thanks!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: macro to filter out data
    ... The best way to get an understanding of how VBA can be used in excel is ... To record a macro Tools - Macro - Record new ...
    (microsoft.public.excel.worksheet.functions)
  • Re: VBA: For Count, when count changes from cell to cell
    ... with Excel 2000. ... reporting Macro being unavailable. ... Sub CalculateI3() ... means that you can refer to it in a cell just like a built-in Excel function. ...
    (microsoft.public.excel.misc)
  • RE: Sorting macro needed on a protected sheet
    ... they all have Excel 2003, before reposting this thread as a new discussion to ... you will still be prompted to enter a password when running your macro even ... closing the password dialog box performed the sort macro anyway without ... Autofiltering can be restored without having to close & ...
    (microsoft.public.excel.programming)
  • Re: Exporting Hierarchy to Excel (Jack`s Macro)
    ... Now an empty Excel ... Sub dwn ... How exactly did you copy Jack's code into the VB editor? ... contains Jack's macro? ...
    (microsoft.public.project)
  • Re: Excel 2007 AutoFilter problem
    ... It confirms my belief that something did change from having used the same sheets and macro for a long time in Excel 2002. ... I mention this because there is at least one known bug I have uncovered as a result of having installed that: the "Analysis ToolPak" and "Analysis ToolPak - VBA" Add-Ins switch without warning to German -- though I run Excel in English -- at some point shortly after installing Office and the Language Pack. ... Clarifying, in case it needs such -- I only apply the filter once too, if by that you mean turn on filtering. ... Oddly, I do not always have auto-filter mode turned off when I run my macro, and in fact usually do *not* have it turned off, so I would not have expected that snippet of code I showed to make any difference as to when in the sheet-generation process it shows up. ...
    (microsoft.public.excel.misc)