UsedRange is read-only. You need to enter something in the cell you
want to be the "end" to make it so.

Mark Lincoln

On Oct 2, 11:43 am, Mike H. wrote:
I wrote this sub:

Sub ResetUsedRange()
ActiveSheet.UsedRange
End Sub

Then i place my cursor in the cell I want to be the end and execute the
macro and nothing changes. Ideas?



" wrote:
On Sep 3, 1:33 am, "Peter T" <peter_t@discussions wrote:
wrote:
How can I change where ctrl-End goes to?
[....]
ActiveSheet.UsedRange ' typically works but not in all scenarios

Works great for me. Just want I needed. Thanks much.- Hide quoted text -

- Show quoted text -