You really don't give us much to go on, so I'm guessing it's an error in your program somewhere...

• Where does $Sheet come from? This would be useful information so we could tell what kind of thing $Sheet is...
• Is $Sheet defined? You'd be surprised at how often this can be the case
• Do you have warnings & strict enabled? No? Those annoying error messages getting in the way?
• What does the VB script look like? We don't know ... you could've made a poor translation of an oatmeal cookie recipe, but without the original VB code, how could we tell?
• What error messages do you get? This would give us a clue as to what the problem is. Without that, I'm guessing that your computer is on fire or something.
• Where's your code? I'm really not terribly interested in trying to write my own program to try to reproduce your error in order to help you fix it. If I did my program would probably work, and then I still couldn't tell you what's wrong.
• What did you expect to happen? Sure, we could infer it from the meagre information given, but I'd hate to solve the wrong problem...
• What *did* happen? Any clues could be helpful. Instead, you're scaring off potential helpers because you're making it too much work to help you.

Well ... that's enough guessing games for me this evening...

...roboticus

Obviously in one of his grumpier moods...