Clear data but not formulla

[anil21]

I am creat a clear data button in excel sheet
i have no vba code to clear data on specific cells on excel invoice

I need to be able to delete the data from the cells without deleting the
formulas. Then the workbook can be reused in its original condition without
having to rewrite all the formulas.

i am send the excel invoice copy
please look the excel invoice copy i am send you
please help us thanking you

cell range :- c14 to f14,c15 to f15,c16 to f16,c17 to f17,c18 to f18 ( BUYERS ADDRESS)
cell range :- c20.f20.g20.h20 to c41.f41.g41.h41 CLEAR THE VALUE NOT( FORMULA)
cell range :- h42 CLEAR THE VALUE NOT ( FORMULA)
cell range :- h43 CLEAR THE VALUE NOT( FORMULA)
cell range :- h44 CLEAR THE VALUE NOT ( FORMULA)
cell range :- h45 CLEAR THE VALUE NOT( FORMULA)
cell range :- h46 CLEAR THE VALUE NOT( FORMULA)
cell range :- h47 CLEAR THE VALUE NOT ( FORMULA)
cell range :- h48 CLEAR THE VALUE NOT( FORMULA)

PLEASE LOOK THE ATTACHED COPY OF INVOICE

[AB33]

Anil,
We could not see your code on the attached. Please explain what are trying to achieve, or show us on a sample?

[zbor]

Try:

Please Login or Register  to view this content.

Similliar for other ranges

[watersev]

hi anil21,

Please Login or Register  to view this content.