Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need macro that would find 1st empty cell in a range and then enter value
(current time) in it. For example I have following sheet A B C D 1 10:15 2 11:20 3 13:50 4 14:32 5 I need macro that would examine column d and find out that 1st empty cell is D5, then this macro should enter current time in D5! This would enter time in currently selected cell ... how do i modify this code for my purpose ? Public Sub InsertTime() With ActiveCell .Value = Time End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Need Macro to Find Column Heading -- if none, then insert new column | Excel Programming | |||
find row value, insert column | Excel Programming | |||
emty excel frame | Excel Programming |