RattlingCarp3048
Board Regular
- Joined
- Jan 12, 2022
- Messages
- 166
- Office Version
- 365
- Platform
- Windows
I have this spreadsheet that just keeps on circling back with problems, hopefully you guys can help once again....
It is updated with new data multiple times throughout the day so the last row is ever changing. the data is in A-Q with formulas going into R-X. Placement of the formulas in V-X is the issue.
When the spreadsheet is updated i need to find the next available row in column V-X and place the formulas. How can i find the next available row in V-X?
if I use lastrow = Cells(Rows.Count, "V").End(xlUp).Offset (1).Row is shows the next row = 9001 but its not, in this update the next cell in column V-X is 8993
It is updated with new data multiple times throughout the day so the last row is ever changing. the data is in A-Q with formulas going into R-X. Placement of the formulas in V-X is the issue.
When the spreadsheet is updated i need to find the next available row in column V-X and place the formulas. How can i find the next available row in V-X?
if I use lastrow = Cells(Rows.Count, "V").End(xlUp).Offset (1).Row is shows the next row = 9001 but its not, in this update the next cell in column V-X is 8993