Sorry, that sounds really wierd, but what I want to do is this:

I have a data table of around 2000 rows and 16 columns. I want to have
a 'Delete Selected Row' button. The idea is that the selected cell and
the 15 to the right of it are cleared. I have the following code:

ActiveCell.Value = ""
ActiveCell.Offset(0, 1).Value = ""
....
ActiveCell.Offset(0, 15).Value = ""

Any cell in the table can be selected for amendment ,but how can I
amend the Button's code so that it only works if the ActiveCell is in
column B?

Thanks in advance.

Steve