View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Weide Zhang Weide Zhang is offline
external usenet poster
 
Posts: 6
Default How to Use AutoFit()

I need to put a long string into a cell but i want it shown in a proper way
so that the user can see the whole content with proper width and height. Can
I use AutoFit() to adjust individual cell width and height? How can I do
that?

excelresultsheet.Cells(i+1,j+1).value=value[j];

As you can see, excelresultsheet is a worksheet type and value[j] are a long
string. I am using Java Script. Thanks a lot.

Weide