Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Height equivalent to xlColumnWidths?
Is there a Row Height equivalent to xlColumnWidths? I have searched,
but have had no luck. Given that I can't seem to do it manually, I can guess the answer, but someone out there may know better ... Many thanks, Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Height equivalent to xlColumnWidths?
What is xlColumnWidths?
-- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Height equivalent to xlColumnWidths?
Jim,
Using the macro recorder to copy/paste Column Widths gives the following : Selection.PasteSpecial Paste:=xlColumnWidths Excel 2000 does not recognise xlColumnWidths (a bug) and a workaround is to use Paste:=8 ... but xlColumnWidths it doesn't work in my Excel 2002 either, but that's another story. Anyway, while the Paste Special dialog has the option to paste Column Widths, there is no option for Row Heights. While the obvious answer is "it can be done in this manner, write some code", I was wondering if there actually is some method .... Regards, Mark *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Height equivalent to xlColumnWidths?
The constant is xlPasteColumnWidths in Excel 2002 and 2003. This doesn't
work in 2000 as you know so since "8" works in all versions (post Excel 97) that may be the way to go. There is no xlPasteRowHeights unfortunately. The workarounds are (1) copy/paste entire rows. When an entire row is copied the row height comes along. (2) A macro that adjusts each destination row to match its corresponding source row height. Good enough? -- Jim Rech Excel MVP |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Height equivalent to xlColumnWidths?
Jim,
THanks for pointing out the 2002 xlPasteColumnWidths. No wonder I couldn't get xlColumnWidths to work! Yes, that is good enough. Ta, Mark "Jim Rech" wrote in message ... The constant is xlPasteColumnWidths in Excel 2002 and 2003. This doesn't work in 2000 as you know so since "8" works in all versions (post Excel 97) that may be the way to go. There is no xlPasteRowHeights unfortunately. The workarounds are (1) copy/paste entire rows. When an entire row is copied the row height comes along. (2) A macro that adjusts each destination row to match its corresponding source row height. Good enough? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set a minimum row height a the same time with autofit row height | New Users to Excel | |||
Row Height stopped growing and Auot-Fit Row Height does not work | Excel Discussion (Misc queries) | |||
the row height should be excatly the height of the data | Excel Discussion (Misc queries) | |||
need to dbl row height without changing height of cell next to it | New Users to Excel | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) |