Clear specific row except active column

[bhsoundman]

Hi All,

I'm trying to clear row 27 when any other cell is active. The catch is I do not want to clear the active column's row 27 cell. Hopefully that makes sense.

Thanks in advance

 

[Micron]

You're looking for what type of solution; vba code? If so then in the sheet SelectionChange event I'd probably get the value of active column row 27, delete the whole row 27 and copy the value back. Easier than trying to delete everything on both sides of a particular cell. I see that you're on a Mac though and I don't know how successful that approach might be.

 

[bhsoundman]

You're looking for what type of solution; vba code? If so then in the sheet SelectionChange event I'd probably get the value of active column row 27, delete the whole row 27 and copy the value back. Easier than trying to delete everything on both sides of a particular cell. I see that you're on a Mac though and I don't know how successful that approach might be.

Yes, I am looking for a VBA solution.

The problem with what you mentioned is that this is already in a SelectionChange event. Copying the value & pasting it back just creates an endless loop.

 

[bhsoundman]

Looks like this does exactly what I need:

Application.EnableEvents = False
Rows("27:27").ClearContents
Cells(27, ActiveCell.Column) = 1
Application.EnableEvents = True

 

[Micron]

I can see that happening if you're using the Change event, but not SelectionChange, unless by "pasting" you are first selecting a cell. Anyway glad you have a solution. Mine was a bit lengthier and I found that I can't put any values back in row 27.