VBA Frustration

[cookeetree]

G'day Excel Gods,

I'm trying to run what should be simple code to clear the contents of a range when a checkbox is ticked.

The checkbox is linked to cell D33.

Sub OneforOne_CheckBox()

If Range("D33") = True Then
Range.("L34:U41").ClearContents
End If

End Sub

The code keeps failing on the middle line.
I've tried changing the range to include the worksheet name - Worksheets("Compaction1").Range.("L34:U41").ClearContents - but it still fails.
Where am I going wrong??? It's driving me nuts!

Any assistance you could provide would be greatly appreciated.

Cheer, Jason.

 

[Cubist]

Range.("L34:U41").ClearContents

There's a period after "Range" on this line. Try removing it.
Also, you don't need the "=True" in the condition check. It's already a boolean.

Sub OneforOne_CheckBox()
    If Range("D33").Value Then
        Range("L34:U41").ClearContents
    End If
End Sub

 

[cookeetree]

There's a period after "Range" on this line. Try removing it.
Also, you don't need the "=True" in the condition check. It's already a boolean.

Sub OneforOne_CheckBox()
    If Range("D33").Value Then
        Range("L34:U41").ClearContents
    End If
End Sub

Thank you for your help. That single period was my downfall! Man, that was driving me crazy!!

The first line works with either the original code or your revision.

Thanks again. Case closed.