Remove only the values from the current row

I have a worksheet where I commonly remove lines. What I don't want to do is delete the row in the sheet, as I always want there to be 50 lines for entries. What I've been doing (for years) is placing my cursor in first cell, hit DELETE, tab, DELETE, tab ... while being careful to skip any cells that contain formulas.

How would I write a macro that will only remove the values from cells in the current row? Then I could just place my cursor in the row, hit a hot-key and voilą, I'm done.

(for some reason, I can't edit my original post)

Now that I think about it, it would be handier if I could perform the above on a range. Then I could highlight either multiple rows or any arbitrary area on a sheet.

Maybe something along these lines.

Please Login or Register  to view this content.

or for a selection

Please Login or Register  to view this content.

... and ...

Please Login or Register  to view this content.

Originally Posted by ByteMarks

Please Login or Register  to view this content.

Thank you! That worked perfectly.