ook fro myour first
copy still active?
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Abhishek Jain
Sent: Wednesday, February 29, 2012 11:33 PM
To: Shankar Bheema
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ saving particular worksheet
Well its working fine on my PC.
Can you share an example file?
On Thu, Mar 1, 2012 at 11:46 AM, Shankar Bheema wrote:
> I tried the following code and during execution the following error is
> coming.
>
> run time error 9,
> Subscript out of range.
>
> Pls provide solution.
>
> regards
> shankar
I tried the following code and during execution the following error is
coming.
run time error 9,
Subscript out of range.
Pls provide solution.
regards
shankar sb
On Wed, Feb 29, 2012 at 4:28 PM, Shankar Bheema wrote:
> thank you abhishek
>
>
> On Wed, Feb 29, 2012 at 12:11 PM, Abhishek Jain wr
Sheets(Array("Sheet1", "Sheet2")).Select
Sheets(Array("Sheet1", "Sheet2")).Copy
ActiveWorkbook.SaveAs "Myfile.xls"
HTH
Abhishek
On Wed, Feb 29, 2012 at 10:29 AM, Shankar Bheema wrote:
> Dear Experts
>
> In my workbook there are several worksheets exists. I wish to save sheet1
> and sheet2 works
