Hi,
I've written a simple macro that copy/pastes a specific range from a source
worksheet to a new worksheet. It copy/pastes as values and formats in order
to eliminate formulas and maintain the source formatting. However, I can't
get the column widths to copy over as well. I can't just copy/paste the
whole column becuse the source range can be variable, and it's not the whole
column (there's data below that I don't want to copy/paste). How do I
copy/paste the column widths of a user defined cell range? The user is
defining the cell range by highlighting the range and then running the macro.
Any help would be greatly appreciated. Thanks.