Copy and paste the worksheet to New workbook..

S

Sudarshan

Hi,

I am able to copy and paste the worksheet to new worksheet
in new workbook. But i have one problem. The worksheet
which I am copying is having VBA Code behind it. When i do
copy paste , VBA code also copies to new workseet. I do
not want the VBA code to be copied..

Any solution...

My Existing Code

Workbooks("Book1").Sheets("Sheet1").Copy
Before:=Workbooks("Book2").Sheets(1)
' This is for remove the formulas.
ActiveSheet.UsedRange = ActiveSheet.UsedRange.Value


Sudarshan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Worksheets To New Workbook 2
Code to copy worksheet 5
Scattered array cells copy to scattered array cells another workbook 14
how to copy worksheet to new workbook with values only 3
VBA code for pasting links -- modifying RDB code for summary workbook 10
Cell values to an array, then array transpose to another workbook 8
help with a basic code? 0
Save As and new workbook new name used in existing code 8

Top