Hi,
Please see the attached file.
I have text data in column A and numbers in column B. I have to format the file as follows
column A width should be 45
column B width should be 10
Text in column A should be wrapped (wrap text)
and some other formats
I have macro to do all these requirements, but the problem is row height. It is bigger for some rows after running my macro (here rows 32 and 36). I want the row height to be 12.75 for row number 32. I have thousands of rows so I can't do it manually for each row. Could you please let me know how to adjust the row height globally based on data length without adjusting the current format?
FYI - If I use the 'AutoFit Column/Row Width' it affects the column width, as per my requirement column width should be 45.
Please help me.
Bookmarks