Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 266
Default Changing the row height automatically in a macro

I have a spreadsheet where the users can enter data in a cell - for example
G26 and the macro will copy the data to another cell - for example B19. The
data is text - it could be one word or several sentences. Word wrap is
turned on - but I'd like to modify the row height so that the data all
appears in the cell. So based on the character count and the column width,
the height of row 19 might need to change. Thanks for any help on this.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row Height Keeps Changing Janet Lyn Excel Discussion (Misc queries) 1 January 6th 09 02:08 AM
Changing row height in the same worksheet Jess Excel Worksheet Functions 2 June 18th 07 10:17 PM
changing the row height to fit Stephen Sandor Excel Discussion (Misc queries) 2 February 20th 07 11:23 PM
need to dbl row height without changing height of cell next to it Excel-Illiterate New Users to Excel 1 May 16th 06 01:08 AM
Changing row height. P Excel Discussion (Misc queries) 2 April 26th 06 05:32 PM


All times are GMT +1. The time now is 09:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"