Converting VBA to VBScript

Hi,

I am trying to convert some VBA I have that works to VBScript. I am hoping that someone might be able to give me a hand.

Please Login or Register  to view this content.

I am getting an error on the line with the RedFont.
The error I am getting is: VBScript runtime error: Object required: 'Rows'

TIA

Hey thanks a lot Norie!

It works perfectly now. [Sorry for the delay. Its Thanksgiving here in the States & I was eating dinner with the family.]

Hi again

I figured everything out except for getting my script to pause while executing, but only if needed.
This is what I was using.
The Error I am getting is: VBScript runtime error: Object required: 'Application'

Please Login or Register  to view this content.

Does anyone have any suggestions?

Perfect thanks again.