Excel Help

[ukpolicekid]

Hi,

I have been searching google frantically and bashing my head against a brick wall :banghead:,

The code is:

Sub Addteam()
' Adds New Team to the draw

ScreenUpdating = True
Load frmnewteam2
frmnewteam2.Show
Sheets("Home").Select

End Sub

And it is returning a runtime error 9
help will be much appreciated!

[shrivallabha]

Welcome to VBAX!
Runtime error 9 (something like subscript out of range) is associated with:
1. The name syntax being incorrect.
2. There is no OPEN item with the specified name or it does not exist.