Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Macro: copy and paste tabs
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Macro: copy and paste tabs
· High Priority · Version 2003
Reply Tue 15 Nov 2011, 15:30Delegate Heather said...
Heather has attended:
Excel VBA Intro Intermediate course
Macro: copy and paste tabs
I use a macro created by an ex-colleague which copied and pasted two tabs from a workbook into a new book.
It was done by recording a macro and in the past has copied and pasted both worksheets as values (both have many formulae). However i have made some adjustments to some formulae and now only these paste as "=N/A" when i run the macro. I have stepped through the macro and it is very early on where the "N/A"s appear.
The coding is as follows:
Sheets(Array("INPUT", "JOURNALS")).Select
Sheets("JOURNALS").Activate
Sheets(Array("INPUT", "JOURNALS")).Copy
Sheets(Array("INPUT", "JOURNALS")).Select
Is there any reason an adjusted formula would not copy accross? THe formula is as follows:
=IF(K26<>0,(VLOOKUP(K26,'CALL AC'!Print_Area,2,FALSE))," ")
Thanks,
Heather
For upcoming training course dates see: Pricing & availability
Reply Tue 15 Nov 2011, 16:09Delegate Heather said...
RE: Macro: copy and paste tabs
I may have worked this our or at least found a if not the ideal solution. The vlookup was looking up values in a seperate tab. I then copied the table the formula was looking up into the current tab which i was copying and pasting, and it worked without N/As i then extended the macro to delete the table once the tabs had been copied.
Do copied and pasted as new book tabs not lookup in other tabs?
Thanks,
Heather
|