AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
Google seems to have everything but !
Is there a good way to find the row number for the last item in "A" column, where item is a specific thing.
e.g. Row number for the last row where Col A = 3?
Or, if easier can you "get" a range ? e.g. all cells = "3" in Col "C" ?
I need to calculate this in Form code, not mousing on worksheet.
Thanks for any help.
Is there a good way to find the row number for the last item in "A" column, where item is a specific thing.
e.g. Row number for the last row where Col A = 3?
Or, if easier can you "get" a range ? e.g. all cells = "3" in Col "C" ?
I need to calculate this in Form code, not mousing on worksheet.
Thanks for any help.