Object Required Error in VB Excel Program that Passes Range to a function

Hi Friends,

I am trying to pass the formula which gives a range of cells to a function called concatenate_Text which is defined as

Please Login or Register  to view this content.

The macro that passes the range is this

Please Login or Register  to view this content.

When I try to execute this, it gives me an error saying "Object Required" error. The catch is "I want to send the results of the formula to the function Concatenate_Text ........
Kindly explain where I am going wrong.

Thanks in advance for your time

Change the last line to:

Please Login or Register  to view this content.

without the parentheses.

I didn't read the line above - you can't assign a range based on a formula like that. Best guess would be:

Please Login or Register  to view this content.

Wow, Thank you so much Romperstomper.. It is working super cool