KenCriss
Active Member
- Joined
- Jun 6, 2005
- Messages
- 326
I have the following code in Userform_initialize.
At work I have Excel 2002(I think) and at home I have Excel 2000. This code has no problem at work but at home I get "Application-defined or object-defined error"
It blows up on the tbl.resize line and not the "Set" line.
I have not a clue what would be causing this unless it's a difference in versions. Has anyone heard of this?
Code:
Set tbl = ActiveCell.CurrentRegion
tbl.Offset(1, 0).Resize(tbl.Rows.Count - 1, tbl.Columns.Count).Select
At work I have Excel 2002(I think) and at home I have Excel 2000. This code has no problem at work but at home I get "Application-defined or object-defined error"
It blows up on the tbl.resize line and not the "Set" line.
I have not a clue what would be causing this unless it's a difference in versions. Has anyone heard of this?