View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gina Gina is offline
external usenet poster
 
Posts: 58
Default "Resizing cells" code doesn't work with merged cells

I got a code I found on this site to resize my cells as I type:

Private Sub Worksheet_Change(ByVal Target As Range)
Set t = Target
Application.EnableEvents = False
Rows(t.Row).EntireRow.AutoFit
Application.EnableEvents = True
End Sub

But it doesn't work on merged cells. Is there an additional code that can
be added to the above to include merged cells?