Thread
:
Resizing Ranges
View Single Post
#
1
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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?
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson