F
Fan924
Excel 97. Trying to follow an example posted to this BBS and I am
getting errors. I am trying to switch easily between workbooks for
copy and paste operations. I need some help.
Sub test()
Dim wb1 As Workbook
Dim wb2 As Workbook
If Workbooks.Count = 2 Then
Set wb1 = ActiveWorkbook
Set wb2 = "c:\library.xls"
End If
Error message reads "Compile error type mismatch" for wb2
getting errors. I am trying to switch easily between workbooks for
copy and paste operations. I need some help.
Sub test()
Dim wb1 As Workbook
Dim wb2 As Workbook
If Workbooks.Count = 2 Then
Set wb1 = ActiveWorkbook
Set wb2 = "c:\library.xls"
End If
Error message reads "Compile error type mismatch" for wb2