On 21 Apr, 08:02, Chris wrote:
I am making.. or trying to make a macro to clear data from fields on my
sheet. I keep on getting different error messages and nothing I have found so
far ( going on 60.00 worth of books) have help me find that anwser.. I am
going to take a class... i am in more urgent needs of anwsers. do.. you want
me to post the code?



Chris,

Use the Clearcontents command:

Range("First cells ref:Second cell ref").clearcontents

e.g. Range("A1:B20").clearcontents

where the range is the range that you want to clear.