royUK,
I didn't mean anything other than I knew what it was that I wanted to accomplish.
Thanks for evaluating my request to make sure I wasn't progessing in an inefficient manner as you pointed out that you saw, "no point in Copying a range & Pasteing Formats.."
But yet still however, thats what I needed to do and what was the basis of my request; which BTW, I thought I posted in a groomed and explanitary manner, unlike many requests in this forum.
Thank you for your input and willingness to help me.
However, I came up with the bit of code below on my own. It took several trials and errors to get it to do what I wanted, but alas it is.
Now I am hoping that some of the more versed coders than I who are here can give me some feedback on my attempt and see if there is a better way of getting this done.
I suppose I haven't added any error checking, but to be honest, I'm not sure what I need to check for.
Any help is greatly appreciated.
Additude.. NOT Attitude...
Edited:
to:
As changing Columns.Count to 1 makes it check the headers where there is a better chance that there will be data in every row cell across the worksheet. As it was, Columns.Count equaled 256 and it just so happened I didn't have some data all the way across in row 256 of ws2, so it gave me a headache for a bit.
Anyway, in case someone copies my code, I updated it.
Bookmarks