Hello:
I am using below statement and works fine
Set SrcRng = xlw1.Sheets(Range("A110").Value).Range("B49")
But I want to change the above statement to allow variables in .Range("Bx") where the the value "x" would be
pulled form Cell A112.
for Example : A112 = 55, then above statement would become .Range("B55")
Please help with this statement.
Thanks
Riz
Bookmarks