RAYLWARD102
Well-known Member
- Joined
- May 27, 2010
- Messages
- 529
I've got a userform that I designed in excel 2003.
I declare pagNew as Page
and the office 2007 and 2010 lock up with a runtime error 13 "Type mismatch"
pointing and highlighting the following line:
Any idea's on how to make this work better in the newer office excel?
The code works perfect in office 2003
I declare pagNew as Page
and the office 2007 and 2010 lock up with a runtime error 13 "Type mismatch"
pointing and highlighting the following line:
Code:
Set pagNew = UserForm1.MultiPage1.Pages.Add(spTY.Range("e" & cell.Row).Value)
Any idea's on how to make this work better in the newer office excel?
The code works perfect in office 2003