oh my freaking goodness, I did it, I finally did it! This is a proble
i've been trying to tackle for at least 2 good months...this was th
solution:

Selection.Resize(,12).Select

I had entered this statement before after the first reply from Tom, an
it wasn't working, but I didn't enter it exactly as you see above,
put in:

Selection.Resize(*0* ,12).Select

I was getting back an error when i ran the macro basically saying tha
the range I was entering couldn't exist. It seems that leaving the
out of the .Resize term was the trick :)

And now, it works!

Thanks a lot for the help guys!! I guess I just needed to fool aroun
with it.

lol, you just don't know how happy i am right now

--
Message posted from http://www.ExcelForum.com