| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Registrate date/time in a specific column for multiply selected rows
Hi Johan,
Am Sun, 15 Oct 2017 21:51:15 -0700 (PDT) schrieb : In an excell sheet I have selected multiply rows which are not always near eachother like row 2 till 5 and with CTRL row 10 till 20 and with CTRL row 30 till 35. Now I want to registrate the actual date/time for all those selected rows in column X try: Sub TimeStamp() Dim myRow As Range For Each myRow In Selection.Rows Cells(myRow.Row, "X") = Date Next End Sub Regards Claus B. -- Windows10 Office 2016 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MsgBox if within selected rows a specific column is not filled in | Excel Programming | |||
| Change Event (How post Date/Time to Changed Cells Rows but different Column) | Excel Programming | |||
| How to multiply column and rows | Excel Discussion (Misc queries) | |||
| How to multiply rows to match the specific value in the row | Excel Discussion (Misc queries) | |||
| In VBA, How to Refer to Cell In Specific Column But Selected Rows? | Excel Discussion (Misc queries) | |||
Threaded Mode
