route217
asked on
Combine two macros as one
Hi Experts Using Excel 2013
How would i combine the two together so macro one runs then two runs...
How would i combine the two together so macro one runs then two runs...
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("$B$3")) Is Nothing Then LoadData
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$3" Then
Call CopyandPasteValues
End If
End Sub
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good to see you Professor after a long time. :)
Thanks Neeraj,
likewise. good to see you too.
yes, it been a long time :-) i have been away summer holidays.
likewise. good to see you too.
yes, it been a long time :-) i have been away summer holidays.
ASKER
Thanks all excelled as always..and excellent feedback..see the error.
You're welcome. Glad to help.