Thread: Setting column width if #### appears in column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
qwerty[_2_] qwerty[_2_] is offline
external usenet poster
  
Posts: 8
Default Setting column width if #### appears in column
If a column is not wide enough for the displayed number, it shows # signs.
In VBA is there a way to detect which cells in which columns have that ###
so I can use column autofit to set to the width needed?


Reply With QuoteReply With Quote