Clear Range on Hidden Sheet

DanGK1 · Feb 19, 2019

Hello

I cannot work out why I cannot clear a range on a hidden sheet.

I have tried the following, but neither work unless I am on the sheet.

Code:

With Sheets("Exchange Rates")
        .Range("B19", Range("B19").End(xlToRight)).ClearContents
End With

Code:

Sheets("Exchange Rates").Range("B19", Range("B19").End(xlToRight)).ClearContents

Any suggestions please?

Thanks

steve the fish · Feb 19, 2019

You missed a dot:

Code:

With Sheets("Exchange Rates")
    .Range("B19", [COLOR=#ff0000].[/COLOR]Range("B19").End(xlToRight)).ClearContents
End With

DanGK1 · Feb 19, 2019

lovely, thank you