View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] stephen.ditchfield@gmail.com is offline
external usenet poster
 
Posts: 24
Default two macros together

Hello
would it be possible to run these two macros together?

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Columns("A:S").EntireColumn.AutoFit
End Sub

and this one

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'disable cut,copy,paste put in sheet you need
Application.CutCopyMode = False

End Sub

It comes up with an error

thanks in advance
Ditchy
Ballarat Australia