Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell resizing | Excel Worksheet Functions | |||
Resizing a sheet | Excel Discussion (Misc queries) | |||
Resizing cells in a selection without resizing entire sheet | Excel Discussion (Misc queries) | |||
Resizing cells | Excel Discussion (Misc queries) | |||
Resizing a listbox | Excel Discussion (Misc queries) |