Under a deadline - need help

[braindiesel]

For some reason, when I use the
selection.value = named range.value line of code, I get TRUE instead of a number that I need for a VLOOKUP
When I rerun the line of code it works,

So, in absence of a better answer,

I want to have the code look to see if all of the values are numbers. If not then I wan to rerun the code a second time.

I cannot use do loop as if this doesn't work I will just be stuck in a loop/

What do I need to do with this
If Selection.Cells.Count <> Range("mySimplyAcctRev").Rows.Count Then

so that the first part verifies that each cell contains a number, not text?

Your help is really appreciated

 

[Glory]

isNumeric(expression or variable to evaluate) returns true/false. So If IsNumeric(...).

 

[Glory]

selection.value = named range.value should be returning either true or false depending on whether the selection equals your named range.

If selection.value = named range.value Then

Vlookup(selection.value, etc etc)

End If

?

 

[braindiesel]

it seems to be working. Thanks for the help

 

[Glory]

Sure.