Range input parameter reads as value not object

I have a function that requires a range object as a parameter. When I loop through the cells in a worksheet I pass a cell into the function to get the result I need. When I run it there is an error claiming that I passed a string not a range object. Here is my code:

Please Login or Register  to view this content.

Any ideas?

Hello jbaddley,

Welcome to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code using the # icon
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

To manually wrap your code, use these Bulletin Board Code Tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.


To learn more about BB codes used in this forum, just click on the link below...

Bulletin Board Codes Tags