Nlhicks
Board Regular
- Joined
- Jan 8, 2021
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
This line of code will take the values in wsUpdate.Range and write the results in the header row of wsUpdate instead of the line that needs to be updated.
lngLastRow = wsUpdate.Range("A" & wsUpdate.Rows.Count).End(xlUp).Row
This line of code does nothing but we were trying to find a solution.
lngLastRow = WorksheetFunction.Max(wsUpdate.Range("A" & wsUpdate.Rows.Count).End(xlUp).Row, 2)
Does anyone have a suggestion that will fix this issue?
lngLastRow = wsUpdate.Range("A" & wsUpdate.Rows.Count).End(xlUp).Row
This line of code does nothing but we were trying to find a solution.
lngLastRow = WorksheetFunction.Max(wsUpdate.Range("A" & wsUpdate.Rows.Count).End(xlUp).Row, 2)
Does anyone have a suggestion that will fix this issue?