Setting text in a macro?

[liampog]

Hi there

Is there a shorter solution to the following code?

Range("F15").Value = ""
Range("F16").Value = ""
Range("F17").Value = ""
Range("F18").Value = ""
Range("F19").Value = ""
Range("F20").Value = ""
Range("F21").Value = ""
Range("F22").Value = ""
Range("F23").Value = ""
Range("F24").Value = ""
Range("F25").Value = ""
Range("F26").Value = ""
Range("F27").Value = ""
Range("F28").Value = ""
Range("F29").Value = ""
Range("F30").Value = ""
Range("F31").Value = ""
Range("F32").Value = ""
Range("F33").Value = ""
Range("F34").Value = ""
Range("F35").Value = ""
Range("F36").Value = ""
Range("F37").Value = ""
Range("F38").Value = ""
Range("F39").Value = ""
Range("F40").Value = ""
Range("F41").Value = ""
Range("F42").Value = ""
Range("F43").Value = ""
Range("F44").Value = ""
Range("F45").Value = ""
Range("F46").Value = ""
Range("F47").Value = ""
Range("F48").Value = ""
Range("F49").Value = ""
Range("F50").Value = ""

I tried Range("F15:F50").Value = "" but this just didn't work at all.

Am I missing something?

Oh, and I can't use .ClearContents as this comes back with a runtime error because of some Worksheet_Change command I have running.

 

[VoG]

You can prevent the Worksheet_Change code from running like this

Application.EnableEvents = False
Range("F15:F50").ClearContents
Application.EnableEvents = True

 

[liampog]

PERFECT!!

Thanks!