Hi guys, as title says, i need to find first column with empty cell in every thrid row in my sheet.
it looks like this
-----------
---------
-------
------
I need to write at each (third) row, new data from other sheet. that part of code is ok, i checked it, it works well...But, for some reason, this code
For t = 5 To 500 Step 3
u = 0
For s = 5 To 500
If IsEmpty(Cells(t, s)) And s > g And u = 0 Then
g = s
u = 1
Exit For
End If
Next s
Next t
Always returns g as 250. I am pretty sure that its just some basic mistake, but i cant find it. Could you help ?