Redefine UsedRange property of Worksheet Object
If the new range address is a string, something like this might work for
you:
For each Cell in Range(WorkingRange)
HTH Otto
"ExcelMonkey" wrote in message
...
I am using the following code to loop through the UsedRange of worksheet:
For Each Cell In sh.UsedRange
I want to replace the .UsedRange property of the worksheet with a new
range
via string variable called WorkingRange which has a new range address i
it.
How do I do that?
Thanks
EM
|