vba line for clearing data from a cell

  • Thread starter Thread starter cvgairport
  • Start date Start date
C

cvgairport

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
 
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!
 
Range("A2,D45,C13").ClearContents. Otto
cvgairport said:
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!
Click to expand...
 
Back
Top