Test Cells if they are numeric

[GBR2L]

Hi,

I'm trying to write a macro that will go down a column checking to check each cell and if it is a number do a calculation based on the value in that cell

I have to search the column to know where to start and finish the search as this cannot be done on the whole column.

I'm new to this can you help

Thanks

[romperstomper]

I have to search the column to know where to start and finish the search as this cannot be done on the whole column.

Please clarify this bit.
The basic test you want is the IsNumeric function.

[GBR2L]

I need to loop through a series of cells, I understand the isnumeric function but I cannot seem to get it to work for each cell going down the column.

The code I have so far does not work and I cannot find the correct syntax.

The code I currently have is where "i" is a row number

if IsNumeric(.Cells([i], [3])) = True Then

If you can help that would be great

[romperstomper]

You don't need square brackets there:

Please Login or Register  to view this content.

(please use code tags around your code, even if you are only posting one line!)