ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,832
- Office Version
- 2007
- Platform
- Windows
Morning all,
I was kindly advised a code for a worksheet i am using but i would also like to use the same code on another worksheet.
My issue is that i get the Ambiguous named detected message because i already have a code using the same name.
This would be Private Sub Worksheet_Change(ByVal Target As Range)
Can you advise how in a situation like this we get around it so it can be used.
On this page in question i have in use.
Private Sub Worksheet_Activate()
Private Sub Worksheet_Change(ByVal Target As Range)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Many thanks.
I was kindly advised a code for a worksheet i am using but i would also like to use the same code on another worksheet.
My issue is that i get the Ambiguous named detected message because i already have a code using the same name.
This would be Private Sub Worksheet_Change(ByVal Target As Range)
Can you advise how in a situation like this we get around it so it can be used.
On this page in question i have in use.
Private Sub Worksheet_Activate()
Private Sub Worksheet_Change(ByVal Target As Range)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Many thanks.