Search results for query: *

Hi Chris, Instead of going from the top and go down, start from the bottm and go up. . . Try this: ActiveSheet.PageSetup.PrintArea = "$C$10:$AC$" & Range("A65536").End(XLUp).Row Thanks! -Gorth

Actually, "Application.ScreenUpdating = True" is not needed, it gets turned back on at the end of a procedure anyway. -Gorth

Hi, This may be a little late but. . . You have to have the application installed. It requires several VBA DLLs and other files as well as Excel.exe. VBA also requires the normal install of registry entries. There is not a way around it. Thanks! -Gorth

Hi, No, there is not a way to do this. The list box that displays the list of macros does not have any properties to set the order. By default, it arranges the list in alphabetical order. Thanks! -Gorth

Hi, The .Delete Method does not support any arguments except for the direction that you want to move. As it is in the help file: expression.Delete(Shift) Here is an alternative: Sub Test() Application.ScreenUpdating = False ' Prevents flickering of Excel and runs faster lRow =...

Hi, I downloaded the add-in and tried to reproduce the problem. I could not find how to get the tool to make a graph. What steps are you using to reproduce the problem? Also, when I downloaded the add-in, there are two files included, statpad_office2k.xla and statpad.xla. Are you using the...