Search:

I have some code that we've been using for years on the older version of Excel. Since we recently switched to the 2010 version the code no longer works. I have a template excel file that I open, add...

It doesn't happen the first time the template is opened, just on the second one.


Workbooks.Open(Filename:="H:\Maintenance\Schedule Template\Rochelle Weekly Schedule Individual...

This didn't work. It allowed me to save the file but with a notification about updating the cells when the book is reopened. Here is what is interesting. When I open the template the first time (in...

Unfortunately there are areas of the book that they need to be able to modify but many other areas that need to be protected. Here is the code.


WsWeekly.Protect ("HorMel2009"),...

Do you want the entire macro code, or just the relevant parts?

Yes, I am trying to protect using a password.

Okay, these seemed to do the trick but now I get this error. Any ideas on how to fix?

99943

We've been using the same macro for years on the older Office versions. Now we have Office 2010 and the macro still works except for saving the workbooks. I've attached screen shots of the errors....

I have been using the same file for months. All of a sudden I get this error anytime I try and use CRTL + any key. Does anyone know why or how to fix?

"Licence information for this component not...

Thanks for your help. I assume I need to declare my variables at the top to make them public?

You can see there are duplicate lines under each case statement. I just want to type those line once in my macro and call to it when needed. What is the best way to accomplish this?? (Sub, Class...

I'm trying to streamline my code by putting duplicate lines of code into a function or another sub. How would I do this?

For example: I have an IF..ELSEIF..THEN statement with many ELSEIF's. After...

A B C D E F G H I
1 M T W R F S O 4/4/09
2

In row 2, the supervisor will enter a number 1 under the day of the week that the work is scheduled. I need range(I2) to subtract...

Here is the formula I have now. I am trying to simplify this formula....any ideas? MATCH, VLOOKUP, ARRAY, etc...??
...

Yes, I am actually deleting the referenced cell. NOT just clearing it.

It looks like I can use the INDIRECT function. It is tedious and looks like I will have to run a macro to populate all of my formulas (30,000) but I've tested it and it works. Check it out.

I defninitly know there are dependents. I was just hoping to make the formula constant. Kind of like using the $ sign for absolute ranges. When I delete the row, the existing row below it has all of...

Just a simple formula: =IF(D7>0, L7)

I have a maintenance work schedule in an Excel file. Rows 1 thru 1000 are individual work orders with hours, date, description, etc. I have formulas from Column AA1:BB1000 to organize the work by...

My problem is this....I'll make it simple.

Column A is filled will numbers.
Column B is filled with formulas referencing Column A.

When I delete a single cell in Column A, I get a #REF! error...

What do you mean by using a class to get the password?

I have a macro that password protects multiple documents and worksheets, therefore, I have a lot of individual lines of code that have the specific password typed out. When I want to change the...

Is there a way to sort a list by the format of the cell? For example: if I wanted to sort by all cells that are filled with the color red.

I am trying to show a timer and progress bar during a macro but when Excel opens and saves each file (large file 22Mb) it hangs for a long time and looks like the application locked up. How do I keep...

Here is the part of the code that takes a long time to run. There are over 1000 formulas in the worksheet that I am inserting the header.


i = WsWeekly.Range("S:S").Find("VALUE", Range("S" &...

Does anyone know why stepping through code runs faster than running it? I have certain parts of a macro that hangs for a long time when running it but steps through the lines quickly when I use F8.

Does anyone know why this loop takes so long? I thought by using ranges instead of activecell, it would speed things up but it actually takes longer. What is the fastest way to execute this code?

...

Yes, I realized that. That was my intention. Is it ok to declare my variables as variant and not be specific on each one?

Could you please give me an example of how to accomplish this?

Does anyone know how to create an animated splashscreen during a long running macro? Or maybe you could just show me how to speed up my macros. Any suggestions would help. Thanks!


Public Sub...

I'm sorry but I cannot upload the workbook. You can write the code using range("A1:A5") and returning the lookup value in range("B1:B5").

A1 = 012
A2 = 013
A3 = 014
A4 = 015
A5 = 016

012 =...

What is the simplest way to lookup a value using VBA in Excel? Here is what I am trying to do. For each cell in a column range I am looking at the value i.e. "05569". That value corresponds to...

I have an Access report that is being generated from a query. I have 1 field with an expression and the rest are normal. When I apply sorting to any of the other fields, it looks OK in the query view...

Does anyone know how to automatically sequence the email recipients in Outlook? For example, I need to setup a signature or voting path for an approval process. The original email gets sent to...

I have 40 images that I want to distinguish between. I want to be able to click on an image, have another form open, enter information about that image and then close the form. Any ideas? I am...

Weird!! I put in a an error handler and the issues went away. No error was triggered though!

Sorry, I didn't notice the date. I was just doing a search and looking for something I needed. I saw it and just thought I would give my 2 cents. Guess I should of looked at the date. Maybe threads...

I already know that, but unfortunitly there is no error that happens. When my VB code gets to (xlApp.Run "'RM Report Macros.XLS'!CGI_Week_Report") then the VBA window opens up and stops at the very...

Weird!! I put in a an error handler and the issues went away. No error was triggered though! :ehh:

It's not giving me an error though. It just opens the VBA window and breaks at the "Sub CGI_Week_Report()". I thought it was because of an error but why isn't it showing me the error?