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

Originally Posted by romperstomper

Change the last line to:

Concatenate_Text TopCell

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....