Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Paste Special Row Heights
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cut & Paste Need Special Macro | Excel Discussion (Misc queries) | |||
Cut and Paste using Macro gives paste special method error | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Macro to Paste Special | Excel Programming | |||
Macro to Paste Special | Excel Programming |