Method of Range_Global issue

Hi,

I can't figure out why this isn't working. Everything works fine but the second to last line gives me an error message saying Method of Range_Global failed. I'm guessing it has something to do with the variable sDataName1, because it was working fine until I added that.

There is more code after what you see here that completes the loop but I just thought it would be easier to include only this code.

I think it's a scope issue, but I just don't understand it. I'm looking more for an explanation than substituted code so that I can try to figure it out on my own. Your help is very appreciated!

Please Login or Register  to view this content.

Thanks!