If I wanted to clear the cell's contents, I would have used:

wksheet.cells(nrownumber, icount).clearcontents

But your code should have worked ok. Are you sure you're looking at the correct
worksheet? And the correct row?



No_Spam wrote:

I have this VBA code to clear cells content, but it is not clearing the
content...

Set wkSheet = Worksheets(sName)

For iCount = 53 To 92
wkSheet.Cells(nRowNumber, iCount).Clear
Next

Why?

--

Dave Peterson