property for blank cell?

[Pjam]

anyone know the macro property to make a cell blank?

 

[xenou]

Range("A1").Clear

Or Range("A1").ClearContents

Or Range("A1").value = vbNullString

Or Range("A1").value = Empty

I suppose all of the above would work. I use the first or second most of the the time - Clear gets rid of everything, ClearContents leaves formatting in the cell.

HTH

 

[Pjam]

Thanks, Is there a way to just reference cells with values in them on a
worksheet. kinda like if i wanted to just reference my range of i would use usedRange ?

 

[xenou]

A lot depends on your purpose. Can you be more specific about what you want to do? In addition to the UsedRange property, you also have the CurrentRegion property, specialCells method, and the typical arsenal of range-defining and cell-finding statements, all of which can be used to define the range of cells you are interested in.

To clear the entire sheet, simply:
Worksheets("Sheet1").Cells.Clear
Or Worksheets("Sheet1").Cells.Delete

That would take care of cells with values

Regards,
AB

Here's some info on special cells if it helps.
http://www.ozgrid.com/VBA/special-cells.htm
Also check out the VBA help files on UsedRange and CurrentRegion.
(Also: type "Locate and select cells that meet specific conditions" in the help box in regular excel to understand better what Excel is doing with some of these selection options)

 

[mvptomlinson]

I'm pretty sure these questions are related..

http://www.mrexcel.com/forum/showthread.php?t=323602