I have an Excel 2002 spreadsheet with several PivotTables referring to the same data source in one of the sheets.
Question 1: I added more rows. How do I tell the PivotTables to use all th...
Is it okay to have an Auto_Close sub in a standard module when you already have a Workbook_BeforeClose sub in ThisWorkbook?
All i need is to copy the formula of the whole column and paste that formula as text in the next column.
I mean let column B has some formula say =A1 +A2
All i need is the text '=A1 + A2 i...
In VBA I want to copy a sheet to a new workbook that will:
(1) Preserve all formatting
(2) Break all links
(3) Delete Toolbox objects
(4) Delete Macros.
I have 1 & 3 nailed but would l...
How do I define a name for a drop down box so that it pulls all of the column headers from Sheets("ABC"). Is there anyway to do this so that it excludes any blank headers? Thanks.
Hi
I have a macro the protects and unprotect a workbook. When I manually unprotect a workbook and try to do something I get the following message:
"Run Time Error 1004:
The cell o...
Hi,
I have selected multiple random rows in my spreadsheet by clicking+ctrl. I have read in my selected rows via:
Dim WorkRng As Range
Set WorkRng = Selection
Now I wish to cycle thr...
I think I found the answer to my question, but I don't have a clue how to implement it. Wonder if an Expert would mind explaining how to accomplish the solution in Question ID 20821010. I al...
In relation to http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21852135.html, how do we close the active workbook without prompting me to save the workbook? Workbook should ...
Hi Experts
It is a good job I became a member of the experts exchange community. I only wish I could help someone instead of always asking questions.
Each time I create a pivot table wi...
Hello,
I am implementing a command bar that allows users to select any worksheet from the dropdown menu in this bar, and also let user to go home, go to the next page, or previous page with a...
Hi,
I am trying to acheive the following, when a macro is run :-
1. Excel asks the user to select a Excel file in the folder C:\Data\Export
2. In the selected file, search for a string ...
Hi everyone,
I have started a small business and am setting up a line of credit with a family member. The line of credit has the following requirements:
Interest only is due on the outst...
Hi Experts,
I'm having difficulties with a series of ComboBoxes on a Userform:
The Userform provides a way for users to create a set of Print specifications that will be used when invoke...
I have two workbooks, wbModel and wbTemplate.
wbModel contains a form that runs a whole bunch of sub routines when various command buttons are clicked.
What I would like to do is run the...
OK...dammit I used to know how to do this! I created a spreadsheet and I have headers or titles at the top of each column and I would like them to remain stationary and visible as I scroll do...
Good morning,
I have tried this a couple of different ways with no success so I decided to ask the experts.
I'm not particularly good at VBA so I used the macro recorder to create the co...
I have a list of items that i need to break into groups and underneath each group calculate the most occuring piece of text in a particular column. I have been kindly given the code to use an ...
Why does the following formula work in excel?
=VLOOKUP(H$1,'sheet 2'!indirect(a1),2,FALSE)
I need to have multiple lookups over different sized table arrays. I am able to get a cell, sa...
=SUMPRODUCT((day="Wednesday")*(weather="Sunny")*attendance)
will return the total attendance at the ball park on sunny Wednesdays.
But if I try to write a VBA function
totalAttendanc...
I have an excel column with addresses as such:
6909 LEWIS & CLARK DR - PLAINFIELD, IL 60544
I need to parse this full address into 4 columns...
Column 1 would have: 6909 LEWIS & CLA...
I was making changes to a program that I'm working on and out of nowhere I started getting "Ambiguous Name Detected" warnings. I realize that this error usually means that I have two workshee...
The below formula returns #REF and I cannot figure out why. Need some assistance...
=VLOOKUP(INDIRECT(Month & "-Contract" & "!" & CELL("address",E2)),EmpFractions,2)
I have a worksheet ...
Hello everyone,
I need to convert a ascii file such as the one below (The spaces and seperation are exactly as in the file, notice the set length of all of the lines, like 52 char for the fir...
Hello,
I'm trying to link two Excel workbooks together. They both have macros enabled. When I copy rows from the first workbook(I'm assuming that I can copy rows with data and without) an...
