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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by langer1

  1. langer1

    pastespecial problems

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

    pastespecial problems

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

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

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

Part and Inventory Search

Back
Top