Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch Error - Copying Data between Workbooks
Can someone let me know why I get a type mismatch error when the
following code is ran? Sub CopyFromLSS() Dim MyDir As Range, lsFile As Range, csFile As Range Dim wsTo As Worksheet, wsFrom As Worksheet Set MyDir = Sheets("WB").Range("B2") 'C:\06\ Set csFile = Sheets("WB").Range("B3") 'CS.xls Set lsFile = Sheets("WB").Range("B4") 'LS.xls Set wsFrom = Workbooks(lsFile).Worksheets("Sheet1") 'Why is there a type mismatch error? Set wsTo = Workbooks("Copy and Paste.xls").Worksheets("Sheet2") With wsFrom .Range("A1:Z1057").Copy wsTo.Range("A1").PasteSpecial Paste:=xlPasteValues 'etc End With Application.CutCopyMode = False Workbooks(lsFile).Close SaveChanges:=False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data type mismatch error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Type Mismatch Error when getting data from another workbook | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Copying data to another worksheet gives "Type Mismatch" error | Excel Programming |