macro
 

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

macro
 

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

macro
 

NO selections necessary..

range("b2").clearcontents

--
Don Guillett
SalesAid Software

"carrie" wrote in message
...
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