Worksheet Change & Worksheet Activate in one worksheet?

[slam]

Is it possible to have both?

I have some simple autofit code (below) I'd like to run as part of both; formulas from other worksheets can impact some cell contents while user input can impact others.

Columns("B:M").SpecialCells(xlCellTypeVisible).EntireColumn.AutoFit

 

[Smitty]

Sure you can.

 

[slam]

Care to explain how? As I understand it, you can only have one Sub per worksheet.