I found this code on the web here -
http://www.vbaexpress.com/forum/archive/index.php/t-31071.html - and assigned it to a command button. It works fine for the entire row but I want to clear contents from left of column E. In other words, clear contents from A to E only.
Dim rStart As Range, rLast As Range, rConstants As Range
If Not TypeOf Selection Is Range Then Exit Sub
Set rStart = Selection.Rows(1).EntireRo
w.Cells(1,
1)
Set rLast = Selection.Rows(1).EntireRo
w.Cells(1,
Selection.Parent.Columns.C
ount).End(
xlToLeft)
Set rConstants = Nothing
On Error Resume Next
Set rConstants = Range(rStart, rLast).SpecialCells(xlCell
TypeConsta
nts)
On Error GoTo 0
If Not rConstants Is Nothing Then
Call rConstants.ClearContents
End If
Thanks!