Have a look in the vba help index for RESIZE

Sub resizetoright()
C.resize(, 5).clearcontents
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rbel" wrote in message
...

While I know how to find blank cells and delete complete rows, how do I
find all the blank cells in column C and clear the cell contents of the
next 5 cells to the right?

Grateful for some advice.
--
rbel