View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
straightedge32 straightedge32 is offline
external usenet poster
 
Posts: 5
Default Automatically resize a cell

I was wondering if there was a way to (via macros) enter text into a cell,
and then resize that cell to accomodate the text? Sometimes I enter text
into cells and the text is larger than the default size of a cell, and I
would like to have code that adjusts the size of the column to accomodate the
entire text (so that I don't have to do it manually).

Is there a fast way to do that? Sample code would be greatly appreciated.
Thanks in advance.

-Mike