Rossco_milkbar
asked on
cell formatting in excel
hi there
we generate a report form our company file and export this to excel - we would like to have a macro that automatically formatted cells in a particular range so that the text is vertical from top to bottom, and then for the row to be automatically justified.
Is this possible?
The cell range we would like to amend is from $I$3:$FS$3
thanks fo ryour help
we generate a report form our company file and export this to excel - we would like to have a macro that automatically formatted cells in a particular range so that the text is vertical from top to bottom, and then for the row to be automatically justified.
Is this possible?
The cell range we would like to amend is from $I$3:$FS$3
thanks fo ryour help
ASKER
Thanks Hgholt - works great, except the display of the cells need to be oriented to the bottom of the cell - currently it is shown at the top of the cell and only show partial text.
Can you make a slight modification??
Thanks!!!!!
Can you make a slight modification??
Thanks!!!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window