Excel Macro Just need to go next ROW if the value is not Numeric.

[Gomes1985]

This code has some syntax error but its generic I cant understand. Says For with no Next I have got an next in code it as I am new at this how can I Skip to next row if the row does not contain a number?

For Each Nextcell In Range(InitialRow)
If Not IsNumeric(Nextcell) Then
IsNotNumber = True
Sheets("GAMMING").Range("B" & InitialRow).Select
InitialRow = InitialRow + 1
End If
Next Nextcell

Any help would be great

 

[Trebor76]

If I just read whats on Column A and NOT provide an output but go to nextline

What's the point in analysing if the cell is numeric or not but then doing nothing

 

[Gomes1985]

thanks Everyone. Its working fine now.

 

[Gomes1985]

Thats to avoid overwriting in Column A with a strings. Thats a requirement