[RESOLVED] Skip cells containing text [Excel]

[Fizziii]

You could always use the below code to just run it if it is a number.

If Application.IsNumber(aCell.Value) = True Then

Edit: I think you would put this after checking if it's a formula...

[Ossewa]

I knew it had to be simple! Thanks a lot.

If I am allowed a follow up question:
Can one split the for loop to skip a certain value, for example:

For x = 1 to 5 and 7 to 10

At the moment I am repeating the code to achieve the same:
For x = 1 to 5
....
....
For x = 7 to 10

But would be more elegant if I could run all in one loop?

Regards