worksheet deactivate not working

[Chewyhairball]

Hi

I am trying to run this code to delete constants from column I when i leave a sheet.

Private Sub Worksheet_Deactivate()

Columns("I:I").Select
Selection.SpecialCells(xlCellTypeConstants, 2).Select
Selection.ClearContents
End Sub


The code runs fine using a button but if i try to run it using worksheet deactivate i get an error

"select method of range class failed" and debugging highlights "Columns("I:I").Select"

any help would be most appreciated

thanks

Rory

 

[Chewyhairball]

Thanks.

I am in the far north of Scotland. Its actually a beautiful sunny day today here so I am off outside to get some.

Thanks again.

Rory

 

[My Aswer Is This]

Wow. Must be beautiful there.
I have been to most parts of Western Europe but never Scotland.
I'm here in central Florida 76 degrees F at 6:34 AM

 

[Chewyhairball]

I guess its not bad here. We holiday'd to Florida for about 10 years in a row. Haven't been for a few years now but was like our second home for a while.

Great fun! I do like a good coaster!

OK..you win on the temperature stakes...thats toasty.