ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,602
- Office Version
- 2007
- Platform
- Windows
Hi,
I have a list of values where currently the range is N4:R52 but in time it will go futher down the page.
I would like to select a value in column N & then be able to delete that value & also the values to the right of it thus being column O,P,Q & R
So select cell N20
Then delete values in cells N20:R20
Many thanks if you could advise where to start as i will then add some Msgbox etc afterwards.
I have a list of values where currently the range is N4:R52 but in time it will go futher down the page.
I would like to select a value in column N & then be able to delete that value & also the values to the right of it thus being column O,P,Q & R
So select cell N20
Then delete values in cells N20:R20
Many thanks if you could advise where to start as i will then add some Msgbox etc afterwards.