View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelBeginner[_2_] ExcelBeginner[_2_] is offline
external usenet poster
 
Posts: 1
Default Remove rows with dates

I tried this macro and it doesn't seem to do anything .. .I found it below.
I was hoping it would delete row with certain dates in a spreadsheet. Is
there something missing in the code?

Sub test1()
Dim c As Excel.Range
x = InputBox("start date?")
y = InputBox("stop date?")
For Each c In Selection
If c < x And c y Then
cell.EntireRow.delete
End If
Next
End Sub