Thread: auto resizing of cells or rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] J.Evans.1970@gmail.com is offline
external usenet poster
  
Posts: 5
Default auto resizing of cells or rows
You can use the AutoFit method.

Columns("B:B").EntireColumn.AutoFit

HTH,
Jennifer

Reply With QuoteReply With Quote