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 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...
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 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?
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?
I have a spreadsheet that needs to have every other line shaded, like accounting paper to make it easier to read. Everytime I sort is by a different column, the shaded lines go with the data and it is no longer every other line. Any ideas?
I am running XP home and just updated to SP2. When navigating in windows explorer to save files, the system freezes. When I click on a folder or use the up arrow icon to navigate up the tree, the system was slowing wayyy down. I'd have to wait about 50 seconds for the selected file to show...
I have a design template from my company that I have to use for all presentaitons. It automatically makes every placeholder filled white with a black border around it. It's driving me crazy. I have to change it on every single placeholder in the entire presentaion. When I try to change it in...
I use outlook to access my company exchange server. I am using sonic wall VPN. It is VERY inconsistent. Sometimes I can connect right away, then for days on end I get the error message that the exchange server is not available... when it is. If I go in thru outlook web access, it's fine and...
I am using outlook 2003 and a VPN client to access company e-mail. If I access it thru a cable connection, or a wireless connection and my home wi-fi network, it works fine. I just got the Verizon "broadband" wireless card and it works great to accessing the internet, however, outlook will not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.