Matt Mali
asked on
Combine two worksheet change events
Hi gurus
Seeking help to combine two work sheet change events to avoid Ambiguous error.
The attached file has 3 macros in place.
1. To sort the contents in selected columns using a button
2. To allocate task to another workbook (Thanks Neeraj)
3. Auto populate date in column L (Thanks again Neeraj).
The second and third are both worksheet change event.
I want to remove the following section of the code from vba#3, to hide rows based on a criteria. This section is not needed in the attached spreadsheet. This was developed for another spreadsheet.
After removing the section from third vba, can we combine the second and third macros, to overcome the ambiguous error alert.
Can you help please.
Team-2.xlsm
Seeking help to combine two work sheet change events to avoid Ambiguous error.
The attached file has 3 macros in place.
1. To sort the contents in selected columns using a button
2. To allocate task to another workbook (Thanks Neeraj)
3. Auto populate date in column L (Thanks again Neeraj).
The second and third are both worksheet change event.
I want to remove the following section of the code from vba#3, to hide rows based on a criteria. This section is not needed in the attached spreadsheet. This was developed for another spreadsheet.
ElseIf Not Intersect(Target, Range("AA6:AA3000")) Is Nothing Then
If Target <> "" Then
If LCase(Target.Value) = "completed" Then
Target.EntireRow.Hidden = TrueAfter removing the section from third vba, can we combine the second and third macros, to overcome the ambiguous error alert.
Can you help please.
Team-2.xlsm
Subodh Tiwari (Neeraj)
I think you forgot to upload the file.
ASKER
Thanks Neeraj for pointing out the error. The file is now uploaded into my initial request .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hurray..its working.Thanks Neeraj
You're welcome Matt! Glad it worked as desired. :)