restart

When I import or export modules from the VBE, my default path was where I wanted it until this past week when I somehow hosed it, and now I have to navigate to get back to it each time I restart Excel (it remains stable in each session). Does anyone know how to change the default path...

Have entered a pagenumber in the header for all sheets in my workbook: &[page]&[pages] For the time being the numbering continues though all sheets. However would like to restart numbering from 1 on each sheet.

I am just starting with JavaScript in Excel, and I have downloaded the "Excel JavaScript UDFS" book from this site. I have installed the sample add-in, but I have a problem with the RangeAverage function: With a large range (e.g. 1 column x >500,000 rows) it returns #NA #. After returning this...

I've tried all the usual solutions. Checking if automation is on. cells are not set to text. Check for Circular References not an issue The strange thing is if I restart the computer it will sometimes work. Corrupt excel or something else?

I'm trying to come up with a formula that can 'restart' a running total after 12 rows. Currently my data looks like this where the running total is calculated using the formula in C2 is =SUM($B$2:B2) This works fine until I reach row 14. Here I would like the formula to 'restart' so it...

Hi, Not sure if terminology correct, but this is what I need advice on... I have a workbook that gives the user a start screen (via coding in Workbook_Open) and then carries out a number of steps. At various stanges they can abort the process and I want to ensure that when this happens...