Macro - clear cells but keep formula

[PEAKCAB]

Hello,

Can anybody help? I have made a form for my purchase orders and all apart from when i run the macro, it works but has a bug with the following

Range("E33:F50").SpecialCell(xlCellTypeConstants, 23).ClearContents

I am trying to keep a simple formula i.e =E33


Thanks,

Richard

 

[Fluff]

How about

Range("E33:F50").SpecialCells(xlCellTypeConstants).ClearContents

 

[PEAKCAB]

Thanks Fluff, Much appreciated

 

[Fluff]

You're welcome & thanks for the feedback