Sorry Rissolo for not making my question clearer. What you have just said is correct.
I have one source workbook containing multiple worksheets and a fixed range (F23:S30)from each worksheet is to be pasted values only to a destination workbook containing one worksheet...
Thanks Rissolo for replying
i understand about activating the destination workbook but i still get run time error of type mismatch. I have tried to define a workbook variable for source and destination a few times but i could not come up with suitable code. I was wondering if you would have...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.