"Expected =" when trying to clear range

[Martunis99]

Hi guys,

I am getting an error of "Expected =" when trying to clear a range.

My code is:

ThisWorkbook.Worksheets("Ind Output").Range(IO.Offset(2, -1).Address(0, 0), Range(IO.Offset(2, -1).Address(0, 0)).End(xlDown).End(xlToRight)).ClearContents

But the following section is returning this error:

ThisWorkbook.Worksheets("Ind Output").Range(IO.Offset(2, -1).Address(0, 0), Range(IO.Offset(2, -1).Address(0, 0)).End(xlDown).End(xlToRight))

I am not too sure what I am doing wrong?

Thank you for your help!

 

[Marc L]

Hi,​

​

'cause obviously you forgot a worksheet reference !​

Expecting IO is defined and matches the great Logic as after all we are not on some mind readers forum :​

​

    With ThisWorkbook.Worksheets("Ind Output")
        .Range(IO.Offset(2, -1).Address, .Range(IO.Offset(2, -1).Address).End(xlDown).End(xlToRight)).ClearContents
    End With

​

​

 

[Martunis99]

Oh man, you are spot on Marc L! Didn't even remember into looking at the second Range. You are totally right, I can't expect VBA to guess to which Range I am referring to.

Thank you so much for your help and I apologize for the hassle!