gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 727
- Office Version
- 2019
- Platform
- Windows
Hello,
Is there another code to use (lOne) so I don't receive the error and doesn't affect the outcome?
lOne for the first and ??? for the second.
I can post additional coding if necessary.
error: 'Duplicate Declaration in current scope'
1st use:
2nd use:
Thank you
Is there another code to use (lOne) so I don't receive the error and doesn't affect the outcome?
lOne for the first and ??? for the second.
I can post additional coding if necessary.
error: 'Duplicate Declaration in current scope'
1st use:
VBA Code:
lOne:
Set xRg = Range("B3", Range("B3").End(xlDown))
xEndRow = xRg.Rows.Count + xRg.Row
Application.ScreenUpdating = False
For I = xRg.Rows.Count To 1 Step -1
2nd use:
VBA Code:
lOne:
Set xRg = Range("L3", Range("L3").End(xlDown))
xEndRow = xRg.Rows.Count + xRg.Row
Application.ScreenUpdating = False
For I = xRg.Rows.Count To 1 Step -1
Thank you