Search results for query: *

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...