clearing data in a cell but keeping the formula

[pm]

I am wanting to erase the data from all fields, but keep the formualas in the
cells. How do I do that! Thanks.

'Clear User Lists on Control Sheet
Sheets("Control").Select
Range("A8:E65536").Select
Selection.ClearContents
Range("A5").Select
Sheets("Control").Cells(5, 1) = UCase(Sheets("Control").Cells(5, 1))

 

[Jerry Whittle]

Access doesn't have cells. Therefore I think that you are in the wrong
discussion group. Try Excel.

 

[pm]

Hi Jerry,

Thanks for your response. Maybe I didn't pose my question correctly.
Within the macro - a range is cleared in a sheet...is there a command that
will retain a formula and only clear the data?
Thanks.

 

[Douglas J. Steele]

As Jerry said, you're talking Excel, and this newsgroup is for Access.

Are you trying to do this using Automation from Access?