Copy/Paste using VBA into a new workbook

**manny_cb** · 02-02-2009, 05:10 PM

Hey all

I am trying to do a copy paste using vba but i keep getting a runtime error
It copies the first part and pastes it at B50 but after copying the sheet to a new workbook.. it fails.. I cant seem to figure out whyy??@@

Any help is greatly appreciated. Thanks

Please Login or Register  to view this content.

**manny_cb** · 02-02-2009, 06:37 PM

any1 ?? basically i have a worksheet with a few vlookup formulas
and I wanna use vba to copy the sheet into a new workbook
but as soon as i copy it into the sheet.. the vlookup formulas are giving a #ref error..

so i figued i cud copy paste values somewhere before i copy the sheet and then copy paste them back into their original position after i copy the sheet into a new workbook.. seemed simple enuff but its not working... :S

any help is greatly appreciated.. if theres a better way of goin about it.. please let me know.. thankssss!!