|
Help with names
I have erased all my defined names (by going to Insert_name_define_delete)
but when I move/copy my tab over or duplicate my worksheet, I get multiple
errrors saying that I have a name conflict and it pops up about 10 names. I
tried to find these names from the error box by using the Define names and
also by trying the Go To function. The names are not there but they have to
be someplace ...
|
3 |
12/23/2008 10:07:55 PM |
|
|
Selecting todays date
Any way to rewrite the code below to choose whatever the current date
is instead of a specific date? =today().
ActiveSheet.PivotTables("PivotTable1").PivotFields
("DATE").CurrentPage = _
"12/22/08"
I am trying to set up the sheet code to refresh the two pivot tables
on the page and then change the dates to whatever the current date
whenever the sheet is selected.
than...
|
4 |
12/23/2008 10:06:42 PM |
|
|
Word doc from Excel using a macro?
I have an Excel file that contains headings that are used to create a word
doc for a training manual. Is there a way I can either auto populate the
Excel headings into Word or select what headings I need and create a macro
that would generate a word doc to populate with text?
Example:
A B C D
1 Title Heading 1 ...
|
1 |
12/23/2008 9:17:02 PM |
|
|
Send Data to specific sheets based on value of one column
I have a user with a request that I know I have seen done before but I
just can't find it on the internet.
The user has a master sheet with all the data. It has maybe 12 rows in
it. He wants to create sheets for each distinct value in column A and
have all the rows where the value of column A is the same be copied to
that specific sheet. I'm not really sure the best way to go about
doing t...
|
5 |
12/23/2008 8:38:39 PM |
|
|
Passing a named range to a function
I have a named range called "Temperature" that is 1 x 10 vector.
I have a function x(ByVal value1 as double, Byval value2 as double) that I
need to run on all 10 temperatures.
When I go x(4,5) the function works.
When I go x(Temperature,5) the function gives #VALUE! error. My intent is
that the function will pull the Temperature value from the vector in the
column above it (or row b...
|
2 |
12/23/2008 8:17:25 PM |
|
|
Application.OnTime question
Hi all,
I'm trying to find a way to kick off an "application.ontTime" without having
to start Excel Manually, so the Macro needs to first start Excel and then run
my application. Is that possible? and how?
--
Thank you......
|
5 |
12/23/2008 7:37:07 PM |
|
|
Horizontal Alignment
I have a Excel document I am creating from data in a Access Database.
I have alot of cells that need to be aligned left, right or center.
Instead of using the Brute force method of defining an alignment for each
individual cell I want to call a Sub Procedure to do the alignment.
Here is my Sub I am calling.
Public Sub AlignRight( _
Optional ByRef rowStart As Integer, _
Optional ByRef r...
|
1 |
12/23/2008 7:27:02 PM |
|
|
Checking cells for input
I have a worksheet that has 107 rows. The number of rows can change as users
add records. The last 3 columns in each row are status's of each record
indicated by one of the cells having an X in it. I want to allow only 1 of
these 3 status cells in each row to contain the value of "X". Any help or
suggestions would be greatly appreciated....
|
2 |
12/23/2008 7:15:27 PM |
|
|
Autofil macro
Hi Guys,
I need some assistance with a macro. I need the macro to grab some formulas
from a static range of cells (B2 - G2) and paste that formula in a static
range (B4 - G4) and then I need it to autofill to the last empty row (the end
of this range is always changing or else I would use a static end range).
For example, today I might need it to fill all the way to B36 - G36 and
to...
|
12 |
12/23/2008 6:44:04 PM |
|
|
Data Manipulation
Looking for some VBA help to automate this task. Basically I'm trying to
create a columnar list of data that includes the account number in column A
from a spreadsheet that displays the data in account number "groups"
1. For each instance of the text “SH†in column B, write the contents of
the cell in that row from column E into the same row in column A
2. Copy the value just writ...
|
8 |
12/23/2008 6:36:01 PM |
|
|
Excel VBA Algorithm
Hi,
I am looking for an advice on this challenging algorithm.
I have a column in ms excel sheet and has the numbers from 1 – 30, and I
need to use vba code to allow the user to be able to change a number at a
time. Then as soon as it is changed, the column numbers need the change so
there is no duplicate numbers in the column. In other words, the column
numbers 1- 30 must have on...
|
9 |
12/23/2008 6:30:04 PM |
|
|
Issue with arrays
I have two functions.
Function A should return a matrix array (mxm) and at some point it calls
function B which has one agrument, a vector array (1xm). The output of
function B should be a vector array (1xm).
Using (probably) a loop, how can I assign each time the output of B as one
row on the matrix of function A?
Something like A(i,)=B(Zi) would work in other languages but what ...
|
6 |
12/23/2008 6:12:01 PM |
|
|
Data collection from multiple excel spread sheets
How do you collect data form multiple excel spread sheets? For example I
would like to find a name of a student and collect all of the final grades
form different teachers excel gradebooks. ...
|
3 |
12/23/2008 6:11:05 PM |
|
|
File Search for Combo Box Usage - Excel 2007
I am looking for a routine that will read Excel files from a folder and place
them in a spot on a sheet for usage in a combo box file selection routine.
Application.FileSearch no longer works in Excel 2007....
|
3 |
12/23/2008 5:58:00 PM |
|
|
Monthly maintenance reminder
I am trying to set up a color timer that alerts me when i need to service my
equipment. I have alot of different machines that need attention at arbitrary
times.
For instance; every 60 days and every 400 hrs.
Also, i was wondering if it is possible to set up a cell to show the
equipment name, then just turn red when it is time to performe maintenance.
Can this be done?
Thanks in ad...
|
3 |
12/23/2008 5:57:01 PM |
|
|
Print a Single Hidden Worksheet?
I have a dynamic workbook with two hidden sheets named "Lists" and "Day
Cost". The only way I can, at present, print out the "Day Cost" sheet is to
leave it unhidden, however I would prefer to have it hidden as it has
formulas that pull the information from the other visible sheets. Can
somebody help me with a macro that would allow me to have both the "Day Cost"
and "Lists" sheet remain...
|
5 |
12/23/2008 5:18:13 PM |
|
|
looping thru named ranges
Hi,
I have a bunch of pairs of named ranges, all of them consist of some
leading identifier followed by LIVE or HARD, for instance spLIVE, spHARD;
RussellLIVE, RussellHARD, etc.
How would I loop through the range collection and copy/ paste values each
LIVE range into respective HARD range?
Thank you,
--
______
Regards,
Greg...
|
2 |
12/23/2008 5:12:50 PM |
|
|
AutoShapes Disappear
Hey all,
I've got a problem with my AutoShapes - recently, they have just disappeared!
But:
I can still see the text they used to contain
I can still click on them to run their macro's
any ideas?...
|
2 |
12/23/2008 5:00:01 PM |
|
|
Disable paste option in worksheet.
Hi,
I have a column where I have applied validation for dates but when
someone uses the paste option then
the validation is of no use.
I want a macro which will not allow the user to paste anything in a
particular column. The user has to enter the date without using the
copy paste option.
Basically i want to disable the paste option in a particular range.
Regards
Heera...
|
2 |
12/23/2008 4:44:44 PM |
|
|
Dynamically Create excel file
I need to export data in a GridView to excel without having office installed
on the server. I need to do this with both freezing a row so it will show on
every page when printed. This can be accomplished in excel 2007 using "Print
Titles". The other thing that's required is that grouping(outlining ) is
enabled with multiple levels. This can be accomplished in excel 2007 by going
into t...
|
1 |
12/23/2008 4:40:26 PM |
|
|
Code or Even ?
hello all,
is there any code or event that doesn't allow to open my work book in any
other computer ? Yes i am protected my WB with PW....
|
7 |
12/23/2008 4:30:02 PM |
|
|
print scaling
hi,
i have the following:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
is there a way i can amend this so that i can instruct to print at 80
percent of original size?
thanks in advance,
geebee
...
|
4 |
12/23/2008 3:38:41 PM |
|
|
Excel on a Network
Is there a way for multiple computers to share a spreadsheet for EDITING
simultaneously?
--
A. Ch. Eirinberg...
|
3 |
12/23/2008 3:29:31 PM |
|
|
Shared Workbook
Hello,
I am trying to find out how to get the details of all users logged in to a
shared workbook.
This information is available in Excel via the Tools | Share Woorkbook menu
but I need to find out how to get that list of user names. I assume Excel is
using Environ("username").
Does anyone have any ideas?
Thanks in advance.
Martin...
|
3 |
12/23/2008 3:28:01 PM |
|
|
Formating lost when cut and insert
Greetings all. I have a workbook with one sheet for every month of the year.
I often have to cut a row out of one sheet and insert it into another sheet.
I have conditional formatting that is the same on each sheet, that I used
format>conditional formatting to enter. The problem is that every time I
move a row to a different sheet, the conditional formatting is lost. Is
there a w...
|
3 |
12/23/2008 3:23:02 PM |