Hi Ryan;

Thanks you very much for your time and help. Your code looks perfect but for
one single body sheet. I have 42 sections in one sheet. Every section have 8
rows individually. When related button will be clicked, code behind should
check just those 8 rows and should fill first empty cell. If all 8 is filled
should give a warning. I don't have problem with warning part, just I
couldn't put the code to check those rows one by one.

Best Regards;

taco


"RyanH" wrote:

I thought about this code. This code is a little faster and more efficient.

Option Explicit

Sub TimeInCell()

Dim LastRow As Long
Dim myRange As Range

'finds last row in Sheet1 Col. A
LastRow = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row

'sets the range to apply times
Set myRange = Sheets("Sheet1").Range("A2:A" &
LastRow).SpecialCells(xlCellTypeBlanks)

'applies time to all empty cells
myRange = Format(Now, "hh:mm AM/PM")

End Sub

Hope this helps! If so please click "yes" below.
--
Cheers,
Ryan


"RyanH" wrote:

This should work for you. This code finds the last row that has a value in
it in Sheet1 in Col. A. It then applies the time to all blank cells.

Sub TimeInCell()

Dim LastRow As Long
Dim myRange As Range
Dim cell As Range

'finds last row in Sheet1 Col. A
LastRow = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row

'sets the range to apply times
Set myRange = Sheets("Sheet1").Range("A2:A" & LastRow)

'applies time to all empty cells
For Each cell In myRange
If IsEmpty(cell) Then cell = Format(Now, "hh:mm AM/PM")
Next cell

End Sub

Hope this helps! If so click "yes" below.

--
Cheers,
Ryan


"taco" wrote:

Hi there everyone;

Again thanks a lot in advance for the time and help. This time the question
is;
I'm trying to write a code which should check the cell if it's empty or not.
If it's empty, code should write the current time into cell. If the cell is
not empty, code should go to the other cell to check if that one is empty or
not.

Here is my unsuccessful code;

________________________________________
Function zaman()
ActiveCell = Time()
ActiveCell.NumberFormat = "hh:mm"
End Function
__________________________________________

Sub ar1open()

Range("D9").Select
If D9 = "" Then
D9 = zaman
Else
Range("D10").Select
If D10 = "" Then
D10 = zaman
End If
End If

End Sub

Best Regards.