Things were working so well. Greg M. was helping me with the last bit of trouble I was having Friday and I was expecting to be finished this morning. Now everything has gone belly up.
For starters, keyboard shortcuts have stopped working. I was able to run the macros manually for a while but then that stopped working too. I may also have the different modules interfering with each other. All I can think of to do is show what I have, so here goes.
Microsoft Excel 2000 (I can have whatever flavor I like but I've been hesitant to have IT change it).
Windows 2000 Professional (Same as above).
I have a module named Formulas. It was written by someone who knows what they are doing and it is full of mathy sciency stuff. It looks something like this but with all the important stuff left out:
There are a lot of formulas in here and I generally don't have any problem with them. To use them, I type the name of the function and some parameters into the cell that is going to display the answer. Works in any cell in any sheet and calculates automatically.![]()
Please Login or Register to view this content.
Apo helped me with the module below. I also pasted some script from the internet to stop and start background processes to make things run faster. I probably did not apply this in the best way or in the right place but it's there.And finally, Greg M helped me in this thread and gave me this:![]()
Please Login or Register to view this content.
This module copies the worksheet and replaces some of the cell formulas with cell values.![]()
Please Login or Register to view this content.
Maybe I am having big picture problems. Sub, function, private, public? I am not good at knowing when to use which. And the keyboard shortcut problem has me baffled. Hopefully it is something simple that an experienced eye can point out easily.
Edit: Sorry, I know this is bad form. Spent so much time on this that I forgot to point out the problems. This is copied and pasted from my last response to Greg M:
I'm having trouble testing anything today. Keyboard shortcuts seemed to have stopped working. The macros seem to work okay if I run them directly but sometimes I get errors. The errors are not consistent either. Sometimes I get an error and sometimes I don't.
As of right now, whatever script I run errs during the copy worksheet part (Method 'Copy' of object '_Worksheet' failed). Aaaaaaannnnnnd Excel just crashed.
Earlier, I was able to get through the copy part but then get an error on this line:
[Select Code] copy to clipboard
wksNewSheet.Range(sRANGE_NAME).Value = wksTemplate.Range(sRANGE_NAME).Value
When stepping in I get: Compile Error: Method or data member not found. The first line, "Sub CopyTemplateWorksheet() is highlighted in yellow but The ".Range" in the last line of code is highlighted in blue.
I have two other modules that might be contributing to my problems. I think I may need to start a new thread just to show the big picture.
Bookmarks