Solved: Clear cell not entire row

[RonNCmale]

Need to clear just the cell and not the entire row. Here is the code that needs changing.


With ThisWorkbook.Sheets("Holidays")
.Rows.EntireRow(i + 1).ClearContents

[GTO]

Try:

With ThisWorkbook.Sheets("Holidays")
.Cells(i + 1, "C").ClearContents
End With

[RonNCmale]

Didn't work but thanks for the try, I'll post all the code maybe that will help

[RonNCmale]

Private Sub CommandButton_Remove_Click()
Dim i As Long
'change listbox name and sheet location to yours
i = ListBox_Items.ListIndex + 1
With ThisWorkbook.Sheets("Holidays")
.Rows.EntireRow(i + 1).ClearContents
End With
populateBox
End Sub

[GTO]

Okay, this may be a dopey question, but just to clarify, you cahnged the column letter as needed, right?

Cells(i + 1, "C").ClearContents

[RonNCmale]

GTO, that wasn't a dopey question. I changed the column letter and it works. So I thank you for asking the dopey question.

[GTO]

:) You bet 'Taz', always nice when it works out so quick:thumb

(BTW, Warner Bros. rules! That stupid mouse can go jump!)