Running Code with F5 vs F8

[AlanAnderson]

Hi,

I have really strange situation. When I run the identical code (far too much to post) using F5 it falls over (one of my variables not being set by if loop).
When I run code using F8 so I can step through it, the code runs correctly from start to finish and finds that variable.

Does this make sense to anyone? Are there any differences between F5 and F8?

Regards,

Alan

 

[AlanAnderson]

Hi Guys,
The re-typing using the variables suggested by Norie has worked - Thank you so much to all of you for your help.
Must say I'm still baffled by fact that error did not show up using F8.

Thanks again everyone, this Forum is an absolute GodSend to newbies like me.

Thanks,

Alan

 

[Norie]

Alan

I'm pretty sure it's nothing to do with F8 vs F5, it could just be something simple like a coincendence.

eg when you tried F8 the right worksheet was active, but for whatever reason when yout tried with F5 it wasn't.

In fact that might have happened if you'd run one before the other either way round because the code is selecting sheets.

Anyway, it's working.

 

[AlanAnderson]

Norie, Think you are spot on. The one big difference between f5 & F8 is that whilst running with F8 I kept on selecting the QuoteFileSheet so that I could see what was happening.
I feel so STUPID!!!!!!!

Thanks a million, btw where is Yaren?

Regards,

alan