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!
 
Sheets("Sheet1").Range("A2, D45, C13").ClearContents


Gord Dibben MS Excel MVP
 
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...
 
You guys rock! Wish I could find a class to teach me these things.

Thanks!

Amy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel VBA 1
VBA Multiple Line handling with Split() 1
Excel VBA setting Ranges 2
Word to Excel: Export comments with text and line number 0
Excel Import Comments 3

Back
Top