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!
Thanks!
Bookmarks