Clear Range on Hidden Sheet

[DanGK1]

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.

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

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

Any suggestions please?

Thanks

 

[steve the fish]

You missed a dot:

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

 

[DanGK1]

lovely, thank you