Range("A1").Select
Selection.ClearContents

Where A1 is the cell you want to clear.

Hope that helps

"carrie" wrote:

Hi,

I need a macro that will go to a certain cell and clear the contents...
like go to B2 and clear out the information that is there.

in visual basic format is fine.

thanks