Dear all,
I posted this problem yesterday, but I could not find my posting in the
discussion group. I would like to repeat it. I am trying to referece variable
range in a loop in different worksheets. I tried, using Range(Cells(...),
Cells(...)), it works when I am working with only one worksheet and when the
worksheet is activated. However, I want it to work without activating the
worksheet and when I am working with multiple worksheets and workbooks too.
The second try, I did was by trying to create a text using concatenate to
obtain Range, but I could not succeed.
I would be glad if someone will answer both of my problems.
Thanks in Advance.
Samirkc