Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If cell value is greater than another cell value, clear contents.
Okay, hopefully this is the last question today!
I've found the below formula in one of the posts here, but my brain has completely failed on me and I'm not sure how to adapt it to my requirements. I have a value which is entered by the user after a prompt, that populates in cell G4 in a sheet called 'Lookup'. For arguments sake, the current value is 30/11/09. I have another worksheet, 'Data', which has a column populated with dates (say column B). I'd like a macro that looks in column B on the data sheet, and clears out any dates which are greater than the value in cell G4. I just want to empty those cells, not delete columns or anything else. Sub sth() Dim cell As Range For Each cell In Selection If cell.Value < 1000 Then cell.ClearContents End If Next cell End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear Cell Contents based on Criteria of another cell | Excel Programming | |||
Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
how do i display cell contents greater than 255 characters in a t. | Excel Discussion (Misc queries) | |||
VBA Clear Cell Contents | Excel Programming | |||
Type into one cell and automatically clear contents in another cell | Excel Programming |