All -
The Paste Special menu has often frustrated me, for I would often make
three trips there for effectively one pasting: 1. Paste Special
Values, 2. Paste Special Formats, and 3. Paste Special Column Widths.
This week I acted upon my frustration and made a userform in
Personal.xls that replaces the Paste Special radio buttons with
check-boxes. Works fine, does it all in one step. The code for the
check-boxes as true is the code from the recorder, fixing the holes for
column width's and data validation's missing constants (8, 6).
"Clever," says I. "Why don't you add to it and do a Paste Special Row
Heights?"
Why? Because I can't figure out how to get at the row data of the
source (copied) range. You select a range and copy, and then select
usually a single cell and paste. How via VBA do I know the row
dimensions of what is in memory--the former selection? I found code on
Google Groups that does this by input boxes. Not what I want.
Microsoft figured it out for columns.
What's the trick?
Thanks in advance.
....best, Hash
Bookmarks