ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   two macros together (https://www.excelbanter.com/excel-discussion-misc-queries/450160-two-macros-together.html)

[email protected]

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


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com