Resizing Ranges
 

Sue,

It shouldn't make a difference whether you execute the code
normally or step through it in the debugger. Perhaps you could
provide the code in question and an explanation of what "doesn't
work" means.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sue McCain" wrote in message
...
I'm trying to resize ranges with VBA. When I step through
the routine using the debugger, it works fine. When I do
it in the midst of a program with fifteen or so ranges to
resize, and run it without stepping through it, it doesn't
work. Is there a timing issue here? Why would it work when
I do it one step at a time, but not when I do many steps
without the debugger?

Resizing Ranges
 

Thanks Chip. I found out why it was acting so erratically--
I had a sheet with named ranges that I was using as a
template--making a copy of it and working with the named
ranges on the copy. That made everything go haywire,
apparently. Once I got rid of the template and copies, and
worked on an original sheet, not a copy, all went well.
-----Original Message-----
Sue,

It shouldn't make a difference whether you execute the
code
normally or step through it in the debugger. Perhaps you
could
provide the code in question and an explanation of
what "doesn't
work" means.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sue McCain" wrote in message
...
I'm trying to resize ranges with VBA. When I step
through
the routine using the debugger, it works fine. When I
do
it in the midst of a program with fifteen or so ranges
to
resize, and run it without stepping through it, it
doesn't
work. Is there a timing issue here? Why would it work
when
I do it one step at a time, but not when I do many steps
without the debugger?


.