You guys rock! Wish I could find a class to teach me these things.

Thanks!

Amy

"Otto Moehrbach" wrote:

Range("A2,D45,C13").ClearContents. Otto
"cvgairport" wrote in message
...
Awesome, but what if the user is not on the cell. I'd like to give the
macro
a couple of cell locations to clear such as A2 and D45 and C13.

Thanks!

"Luke M" wrote:

ActiveCell.ClearContents
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"cvgairport" wrote:

Hi all -

Is there a line of vba code that I could put into a startup macro to
empty a
cell of data. I want to keep the formatting and any cell comments.

Thanks!

Amy