Re: Redefine UsedRange property of Worksheet Object

Tech-Archive recommends: Fix windows errors by optimizing your registry

If the new range address is a string, something like this might work for
you:
For each Cell in Range(WorkingRange)
HTH Otto
"ExcelMonkey" <ExcelMonkey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9DE6EEF8-44D7-49B8-A8FA-B934EF175ECB@xxxxxxxxxxxxxxxx
I am using the following code to loop through the UsedRange of work***:

For Each Cell In sh.UsedRange

I want to replace the .UsedRange property of the work*** with a new
range
via string variable called WorkingRange which has a new range address i
it.
How do I do that?

Thanks

EM


.

Quantcast