Variable Problem

[radlernyc]

Having trouble passing through a varialble. Variable = Name

Name = Range("F17").value

F17 is text. It works when F17 = a number.

Thanks for the help.

 

[Norie]

What's the problem?

How have you declared Name?

By the way you should try and avoid calling variables things like Name, which is a property of various objects in VBA.

 

[radlernyc]

Thanks... changed the variable name and it work fine.