Select a cell to then delete cells to the right

[ipbr21054]

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.

 

[ipbr21054]

Thanks post #9 did it for me.

Have a nice evening