Why not
convert to values
copy to NEW
rename
save
close
close original
-Original Message-
From: rajan verma
Sent: Sunday, September 11, 2011 1:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Moving Sheets
Hi
Try This
Sub GetALlSheet()
Dim sh As Worksheet
Hi
Try This
Sub GetALlSheet()
Dim sh As Worksheet
Dim wb As Workbook
Set wb = ActiveWorkbook
Application.Workbooks.Add
For Each sh In wb.Sheets
sh.Copy ActiveWorkbook.Sheets(1)
ActiveSheet.Cells.Copy
Selection.PasteSpecial Pas
I would like to thank y'all for your help
On Sep 10, 11:41 am, NOORAIN ANSARI wrote:
> Dear Bom,
>
> Use simple way...
> Please open both workbook..
> and right click on particular sheet and move it to another opened
> workbook.where you want to move...
>
>
>
>
>
>
Dear Bom,
Use simple way...
Please open both workbook..
and right click on particular sheet and move it to another opened
workbook.where you want to move...
On Sat, Sep 10, 2011 at 12:54 AM, bom wrote:
> I would like to know whether its possible to move sheets
IF??? I understand just copy>paste values>copy .
-Original Message-
From: bom
Sent: Friday, September 09, 2011 2:24 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Moving Sheets
I would like to know whether its possible to move sheets from one
workbook to another without t
