Solving a "run time error"

[glide2131]

am looking for help on this macro. I keep getting "run time error 13" (error 2015). With the following line:

Please Login or Register  to view this content.

The macro basically inserts a formula in cell "R2" then if the value is less than or equal to 10 it will copy and paste the row.
If I plug in another cell other than R2 than it copies every row and does not filter out the values that are more than 10.

Does anyone know what I am doing wrong? I have attached the excel file.

Thanks

[Norie]

You don't have a function called GetMiles, so the formula in R2 returns #NAME!.

[tehneXus]

this:

Please Login or Register  to view this content.

is producing an error into Cell R2, when you try to compare an error with a number you'll a get a type mismatch.

you can check the value first like this:

Please Login or Register  to view this content.

apart from that, where is the function 'GetMiles' ??

[glide2131]

Thanks for your reply, here is the function:

Please Login or Register  to view this content.

[tehneXus]

Check the 2nd row in sheet 'Comps', should be a value, not a heading?!

[Norie]

When I put that function in a module the error changes to #VALUE!.

By the way, the only way I could get the code to run was to add some blank sheets.

It doesn't get past this otherwise.

Please Login or Register  to view this content.

As well as the code for GetMiles are there sheets missing?

[glide2131]

That did it!. Thanks