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 = True
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.