View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dancecommander81@hotmail.com is offline
external usenet poster
 
Posts: 1
Default Run this macro whenever the worksheet changes

Hello,

I have the following macro which I wish to run everytime the contents
of any cell is changed in the worksheet.

Could someone please advise?

Many thanks,

Richard Thorneycroft



Sub AutofitSelection()
'
' AutofitSelection Macro
' Macro recorded 25/01/2006 by RT
'

'
Columns("A:F").Select
Range("F1").Activate
Selection.Columns.AutoFit
Range("A2").Select
End Sub