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

[navs8603]

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

[romperstomper]

Change the last line to:

Please Login or Register  to view this content.

without the parentheses.

[navs8603]

Change the last line to:

Please Login or Register  to view this content.

without the parentheses.

Hi Roomperstomper,

I tried, but did not work..
I think its to do with the object definition. I am declaring the range variable.

but some one please tell me, how to "Set" the range variable with the result of the formula....

[romperstomper]

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.

[navs8603]

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