Hi there.

I hope i`m posting it in the right place but since big "i" balloon forwarded me to this place than it might be
By first i am quite new to VBA but i have one complicated job to do with several excel files.

What i need is to select and count cells from ~19 different excel files and combine it into one workbook. I somehow have done everything to the point where my vba selects data from one file and writes info from it into active workbook
My idea after this step was to write path`s of all files and range("x") from where my scrip should start counting those cell, into 2nd sheet of my active WB and then create Dynamic "wbRem.Sheets(1).range("x").Select.

So my main problem now is that when i run script with "wbRem.Sheets(1).range("C251").Select" it runs with no problems (wbRem = path to other file) but if i run "wbRem.Sheets(1).ransel.Select" it gives me Error "Object doesn`t support this property or method"

ransel will be dynamic but for now i have just like this:
(dim ransel as range
set ransel = range("c251"))

What am i doing wrong and how can i make it right?
And sorry if this is not the right place to look for help.

Best Regards