[nyoshu]

delete contents of A5:A475 I need to get a script for my excel sheet that will delete the contents of A5, if E5 = a date (This date varies every day). The contents of A5 are simply a period, to help with a formula I'm doing. Once I put a date into E5, I want that period to be deleted automatically. As well, I need the same thing to be done from A5 down to A475, corresponding with E5 down to E475. There's 6 worksheets in this workbook, and this will need to be done 5 or 6 times on each sheet. A5 to E5, G5 to K5, L5 to P5, and so on...

Does that make sense? Is there an easier way to do this? Thank you!
Specifically, if E5 or E6 or E7, etc are a date (5/19/08, 5/20/08, etc), then A5 or A6 or A7 contents need to be deleted. Maybe that clears things up!

[blake]

Well, if you want to clear contents you're going to need to run a vb script. I'm not sure if that's what you're looking for but i'll give you a simple answer since I don't know a ton about vba and I would basically have to record and re-write a macro for it.

I'm going to assume that this date you're talking about that changes daily can be put in a cell, let's say that cell is "A1"

Here's what you would put in A5

=IF(E5=$A$1,"",".")

What that will do is create a blank cell if E5 matches your date, and if it does not match that cell, it will put a period in the cell for you.

I don't know if that helps or not but good luck!