Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
I have three command buttons all using virtually the same code, but calling different sheet numbers. The first two buttons work perfectly but the third keeps displaying this error code whenever I select a name in TextBox 1 which is the same function in the other two). Command button one calls sheets as "sheet_num = Array (1, 2, 3). Button two calls sheets as "sheet_num = Array (14, 5, 6) and button three calls sheets as "sheet_num = Array (7, 8, 9, 10, 11).
Can anyone suggest what I might be doing wrong?
Many thanks.
Mel
Can anyone suggest what I might be doing wrong?
Many thanks.
Mel