Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove non-business days between dates | Excel Discussion (Misc queries) | |||
Format time column to remove dates | Excel Discussion (Misc queries) | |||
remove rows in one sheet from similar rows in another | Excel Worksheet Functions | |||
remove dates is the middle of a line | Excel Discussion (Misc queries) | |||
remove dates from chart | Charts and Charting in Excel |