Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
pastespecial problems
I have a workbook with 15 worksheets and i am copying a fixed range one after the other to a new workbook.I only wish to copy the values only as cell within the range contain formulas. The code below keeps giving me run time errors mainly "type mismatch" . i would be very greatful if...- langer1
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
vba trouble copying values only from one wrkbk to another
I'm having a little trouble with the following program. The program collects a fixed range from several sheets in a workbook, copies all of these ranges and pastes them one after another on one worksheet in a new (Destination) workbook. The problem is that all of the cells within a range contain...- langer1
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
