Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I found the macro I need to automatically display the current date and time
when an entry is made in the row. The problem is I only want it to look at the adjacent column. I don't want it to start at column A and I don't want it to look at the entire rows entries. How to I specify which column/cells the macro is applied to and how do I make it look at only the next columns entries? There are other columns/data in my worksheet I do not want effected. Here's the macro I'm using. Please help and/or tell me where I can get this info. Thanks in advance. Macro I'm using is below. Private Sub Worksheet_Change(ByVal Target As Range) If target.row = 1 then exit sub 'don't touch if 1st row If target.column = 1 then exit sub 'don't touch with macro if target is column A If IsEmpty(target) then exit sub 'allow deletion of cell content in entire row If Not IsEmpty(Cells(Target.Row, 1)) Then Exit Sub 'ignore if already has a value Cells(Target.Row, 1) = Now '--Column should be preformatted End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |