Search results for query: *

I have a workbook with monthly account lisitngs. Each month is on a seperate worksheet and the customer lists are simelar. I need to compare the two lists - match up the numbers for each identical customer name and identify any rows that are on one month's report but not on another. Any...

I just got a new computer and it is configured to open only one IE window at a time. I can't find the setting to change that. If I have a web page open and I minimize it and click on IE, it closes the open page and navigates to the home page again.

I have an excel spreadsheet with a macro in it that my co-workers need to use. When I copy the spreadsheet to their computer and try to run the macro, I get the following error: "compile error - Named Argument not found. DataOption1:=x1SortNormal" What does this mean?

I have spreadsheet with a macro that sorts it alphabetically at the end of the macro. After I made what I believed to be unrelated changes, now the sort does not recognize the headers. For example the lable "last name" is no longer in the header cell, but is replaced by the first entry...

I need to be able to enter the month myself.... Thanks

I have a simple macro in excel that I would like to change the date in the header before moving on... how do I tell the macro to pause and wait for me to type in the Month? I am VERY much a beginner in VBA.. so be gentle!

I have a simple macro in excel that I would like to change the date in the header before moving on... how do I tell the macro to pause and wait for me to type in the Month?

I have macros in my personal workbook that my co-workers need to use. we are not on a network. How can I copy them and e-mail them to someone else and how do they get it into their personal workbook?

I am trying to count the number of dates in a calendar spreadsheet that have an entry in a certian place...The formula i am using is: "=COUNTA(D4,G4,J4,M4,P4,D11,G11,J11,M11,P11,D18,G18,J18,M18,P18,D25,G25,J25,M25,P25,D32,G32,J32,M32,P32)" It is not displaying as a formula,,, it shows the...

It's not quite that simple. I have reset the security to low and am still having the problem. what is the best way to copy macros? Should I copy the whole Personal.xls file? Rename it?

I have several macros recorded in the personal.xls workbook on my laptop. I need to be able to copy those and give them to my team members. I keep having secrutity problems. What is the best way to do this?

I have a cell with date and time in it. How can I seperate that data into two cells?

Thanks so much.. sorry about the search.. I don't seem to ever come up with anything even remotly like what I'm searching for. I did try, but got all kinds of unrelated stuff.

I am VERY much a beginner and would like to find some resource (class, book....) that would start at the beginning. I often record Macros in Excel, but I can't edit them in any way. Any suggestions for how to learn the basics?

I need excel to change the format of a series of number to always be 10 digits. Some are 8 some are 9, but I need to add 0, or 00 at the beginning so that all numbers will be 10 digits. Any Ideas?

Thanks for the reply... unfortunately I do not know how to edit a macro once it is created. Can I record one with a pause or place to enter the file name? I'd like to be better with VBA, but it is Greek to me. I can't make heads or tales of any of it. I wouldn't have the first idea how to...

I have my recorded macros saved in my personal workbook so that they will work with any open file. How can I send this macro to someone else that needs to use it? Thanks!

I need to record a Macro in Excel that will stop and prompt me for the file name to open. I am not good with VBA, but I can record simple macros. (can't edit them after they are done) Can this be done?

I have some posters that are all on one powerpoint slide. Every time I try to print it, I get about 1/6 of it because it prints out way to large. I've tried every way I know to resize it in the print option. Any ideas?

this worked well - thanks for the tip. Just one more question. I have two columns that need to be formatted a different color, and when I used this conditional format, they change to this alternating grey and white also. Is ther a way to go back and override it for certian colunms?