Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
My knowledge of VBA is very limited. I need help in trying to make a macro I have do an additional step. I have a column (D) in a worksheet that is showing time values (2:30 PM, 3:15 PM, etc.). I need to code the macro so a user can enter a time value and the macro will then delete any rows in that worksheet in which the corresponding cell in column D shows a time value LESS THAN the value entered by the user. I've seen a couple of macros that delete rows matching a string in a cell but nothing that deletes based on the cell value being less than. I would appreciate any help you call can offer. Also - I need this to be done as a macro. I know how to filter the column manually to get what I want but I need this as a macro so people who are not familiar with Excel can simply open the workbook (I have the macro set to run automatically), enter the time value (ex. 2:30 pm) and they'll get all the rows in which the time is greater than or equal to 2:30 pm (the rows with an earlier time having been deleted by the macro). Thanks in advance. MP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date format changes when inputed from user form | Excel Discussion (Misc queries) | |||
only allow one cell inputed for a range of cells | Excel Discussion (Misc queries) | |||
How do I formate cells in excell to show inputed date as 09/13/ | Excel Worksheet Functions | |||
VBA: Return Searched Value Inputed by End-User | Excel Worksheet Functions | |||
Macro to delete rows with text cells | Excel Programming |