Hi,
I am trying to create a macro to import data from one spreadsheet into
an area of another spreadsheet. I have formulas in the adjacent cells
to the import area that update with the new data. When I create a
macro and do Import External Data it just pulls in the same file
everytime. The pr
Hi Folks,
Everytime, when I open MS Excel the Workbook in which all my Macros are
saved opens up automatically. Is this the Normal Macro Excel behaviour? Is
there any way I can suppress the Macro Sheet while my normal Excel workbooks
opens up.
Your help will be highly appreciated.
Regards,
Swapn
Presumably when it finds the occurrence, it activates the sheet the
occurrence is in, so:
var_SheetName = activesheet.name
should do it
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this gro
thanks a lot, avinash! :)
On Aug 30, 7:03 pm, "avinash verma" <[EMAIL PROTECTED]> wrote:
> Below is a smaple snippet that shows how to use
>
> -- to select the properties
> For Each chrt in ActiveSheet.ChartObjects
> chrtName = chrt..Parent.Name ' chrt name
> if chrtName = "Chart1" the
I can do this. But, I think you should do your homework by yourself. Please
try to do once, if you can't then ask for help.
Akhilesh
On Sun, Aug 31, 2008 at 7:57 AM, <[EMAIL PROTECTED]> wrote:
>
> Y values - I have y-values in 2 rows of my spreadsheet, say A5:W5 and
> A10:W10.
>
> X values - The
