Lets try again
04-25-2013, 06:28 PM #1 jak33
View Profile View Forum Posts Private Message
Registered User
--------------------------------------------------------------------------------
Join Date:04-25-2013
Location:london
MS-Off Ver:Excel 2007
Posts:1Excel VBA Copy master sheet into a new workbook
Hi,
Please help as I am stuck!!
I have a macro which copies data from a master excel sheet into a new excel workbook without the formulaes but with the formatting. The below code works fine, but i have a data validation cell which i would like only the value to be copied but this code seems to copy all, also I have charts on the master sheet when copied onto new workbook they still are linked to the series. How can i delink or simply copy as a picture rather than a chart.
Thank you
Bookmarks