I have Office 2007 installed but when I go to Excel and try to import data from Microsoft Query and then chose "MS Access Database" the dialog window that appears only lets me choose MDB files...
My boss wants me to calculate a pivot table that summarizes percentage of row by volume, and percentage of row by units(count). I have no idea how to do this, since I am pretty sure you can't...
Without using code, changing the size of the columns or font, I need to make the contents of the cells in the 'changing' range of E16:AB64 'bleed over' into other cells if the particular cell ...
I'm trying to debug VLookup in VBA for a much larger UDF. I noticed that I get different results when I use VLookup in VBA than I do when I call it from an Excel cell.
I've whittled the pro...
Hello all,
I am curious to know if there is a way to open a file say C:\myfile.xls and take any data in the Excel Column, A for example of all worksheets, and if there is a space before and...
I am using Excel to query our business system for equipment data. I need to sort by the category in column "S" and then insert a line above each category with the category name. Column "S" h...
We have milestone trackers that generally have sections with two columns. One column has a date and the other has an "A" or "P" to clarify whether the date is "Actualized" and "Proposed." What...
Hi
I have two string times "11:00" and "14:00"
What code would I use to check at 12:00 midday that the time now is between these two times.
Thanks
Hello
Is there a way to fill a column with "autonumbers"
ex. from 1 to 20
if yes - can a person do from 20 to 40 for ex?
I have an excel document with about 10 worksheets in it. I have Adobe PDF printer installed. When I print entire workbook to PDF it wants to put each worksheet on its own PDF. I need all works...
MsgBox InStrRev("1-2345", "-") gives me 2 but I am expecting 5
MsgBox InStr("1-2345", "-") also gives me 2 which is as expected.
Question: Why I am not getting the correct return w...
Cannot run macros. Getting 'error loading dll' message. No idea where to start. I have tried to reload excel with no apparent correction.
related to the worksheet found in Q_23772011
I need to have validation for each of the cells in D4:G7 and D19:G22.
Requirements:
1. Only one player can win (receive 10 points) for a ...
I have "First Last" in A1, and want to populate A2 and A3 with First, and Last respectively.
i am guessing i cando this with a split based on the space, then mid.. but i'm not sure about th...
I have a userform in excel 2003 and here is what I'm trying to do:
1. Open another workbook that I've saved as a template... ("c:\theform.xlt") (I've added a cmdbutton to the userform)
2. ...
I sometimes get data (imported) that has extra spaces at the front. This makes the other code not work quite right.
I really need two things: A way to check that for an entire column of ...
Is it possible to use macro code to hide sheet tabs on excel? For instance say I have 7 sheets on a workbook.
sheet 1, 6 and 7 would be visible.
2,3,4 and 5 would be hidden.
A hyperli...
I am new to conditional formatting. I am most interested in blanking out the #NA that results from a formula. While I want the #NA to exist in the cell, I do not want to see it. It has been...
Hi Experts,
I am using a code in visual basic that used to work just fine until today that I installed excell 2007.
The error message says: "COMPILE ERROR: SUB OR FUNCTION NOT DEFINED"
with...
I have a Finance Director (VIP to my position) who claims:
"While I am working on the budget, if someone sends me an email and I click on the icon in the lower right hand screen, the PC jum...
This sub gets an error 1004 at: ActiveChart.Axes(xlCategory).Select
Using the mouse, I CANNOT select the Category axis, nor is VBA able to select it. In a previous attempt in VBA I select...
see attached workbook..........
Hi Experts
My data in worksheet "Volume Summary" keeping on shiftinig down when a new supply customer is add to worksheet "Deal Selection", if you follow ...
Hi Experts,
Is there a way to call udfs saved in personal.xls without having to use the whole prefix:
=personal.xls!myudf(parameters)
Thanks,
Thomas
Hello,
instead of manually inserting a blank row between each row on excel sheet - is there a way to insert blank rows at same time? between each row?
thank you
Hello, I'm working on a module that will take an Access query and parse the information based on a field (AgentName) and a transaction date (tdate). Then the module will export that filtered ...
