RobbieC
Active Member
- Joined
- Dec 14, 2016
- Messages
- 376
- Office Version
- 2010
- Platform
- Windows
Hi there, I need to define a range on a sheet in column A, eg. A1:A15 (15 values)
However, the number of values varies depending upon what has been inputted. Is there a way to define the range up to the last cell with a value and discount anything after?
If you can point me in the right direction, that's be brilliant. Thanks
However, the number of values varies depending upon what has been inputted. Is there a way to define the range up to the last cell with a value and discount anything after?
If you can point me in the right direction, that's be brilliant. Thanks