P
pol
Hi all,
I kindly request your help how to find a row is empty row. For example in
my following code I have to give one more condition also like
if rowcount >= currow and rowcount is not empty // How I can give the
condition
Original code as follows
LastRow = Range("G" & Rows.Count).End(xlUp).Row
currow = ActiveCell.Row
For RowCount = 1 To LastRow
If RowCount >= currow Then // I need to check row is empty or not
If Range("A" & RowCount) = "" Or Range("A" & RowCount) = 0 Then
Range("A" & RowCount) = Col_A
Else
Col_A = Range("A" & RowCount)
End If
end if
Next
With thanks
Pol
I kindly request your help how to find a row is empty row. For example in
my following code I have to give one more condition also like
if rowcount >= currow and rowcount is not empty // How I can give the
condition
Original code as follows
LastRow = Range("G" & Rows.Count).End(xlUp).Row
currow = ActiveCell.Row
For RowCount = 1 To LastRow
If RowCount >= currow Then // I need to check row is empty or not
If Range("A" & RowCount) = "" Or Range("A" & RowCount) = 0 Then
Range("A" & RowCount) = Col_A
Else
Col_A = Range("A" & RowCount)
End If
end if
Next
With thanks
Pol