Run-Time Eror 9

[SDale]

Good morning all.

I was wondering why I get this error sporadically. I have a Form that is used to enter new records on a Pipeline Forecast Report worksheet called "Forecast". What I have noticed is that if I have the Forecast worksheet on my display with the Form in the foreground it works fine. However, if I have another worksheet on my display with the UserForm in the foreground I'll get error 9 (the reason for another worksheet [typically a quote] is so the user can take information off the quote and enter it into the form. The error occurs if a line of code such as,
Sheets("Forecast").Select, or, a Set command is encountered. Is this because the Forecast worksheet needs to be active on my display instead of a different worksheet? If so, how do I make this happen with code so another user doesn't encounter this error. I am new to VBA and still learning all the ins and outs. Thanks in advance for any assistance.

 

[mole999]

try nameing the workbook

workbook(name).sheets("forecast").select

excel is probably complaining the name isn't in the active worksbook

 

[SDale]

try nameing the workbook

workbook(name).sheets("forecast").select

excel is probably complaining the name isn't in the active worksbook

Looks to have done the trick, thanks very much.