|
calculate the sum of characters in a cell
is there a tool to calculate the sum of characters in a cell?...
|
9 |
25.09.2006 18:05:01 |
|
|
How can a cell be formatted to display architectural units?
...
|
1 |
25.09.2006 17:57:01 |
|
|
VBA Range definition: Code needed
I'm new to using VBA, and am trying to create some code to run a daily macro.
The element of the code I'm stuck on is this: I import a daily excel sheet
where I need to have a simple formula that is:
=G1-Sum of "Range"+G2
The "Range" I need to define always starts with cell F11, and runs down the
F Column a variable number of cells. If I do this manually, I choose F11,
then hit Ctrl+...
|
9 |
25.09.2006 17:40:02 |
|
|
Assign a macro to a command button
Hi and thanks for the help. I am using Excel 2003.
I accidently used the wrong button and am hoping there is a fix. I need to
run a macro from a button.
I know that if I use the button (control button) from the forms toolbar the
first thing it asks me to do is to assign a macro and all would work fine.
But...
I used the command button from the control toolbox to make the buttons (I...
|
5 |
25.09.2006 17:38:08 |
|
|
Assigning a macro to a command button
I posted this question earlier today but I forgot to mention an important
item. The right click, assign macro choice is not available with the button I
used (the command button on the control toolbox.) Here's the earlier post.
I accidently used the wrong button and am hoping there is a fix. I need to
run a macro from a button.
I know that if I use the button (control button) from the ...
|
2 |
25.09.2006 17:34:01 |
|
|
Editing Comments - Excel 2000
Using Excel 2000, one numeric column has a number of comments in various
cells. By pointing at the comment indicator I can dislay the comments and by
right-clicking over it I can delete the comments but I cannot edit the
comments. This is with the exception of the last comment (in the same column
and range), which I can edit. The sheet is not protected, I do not have
multiple sheets s...
|
5 |
25.09.2006 16:49:02 |
|
|
have one cell display text which reflects a number in another cell
Hi!
I'm sure that this will be a 'given' to most of you. I enter data into time
sheets daily
where i have to enter the job code as well as the job name ie: cell A1, the
job code in A2, I will type the job name . Is there a way to set this up so
that when i type the job code in A1, the job name will display in cell A2?...
|
4 |
25.09.2006 16:49:02 |
|
|
Moving Check Boxes
I have a class registration form built in Excel which features a column of
check boxes that flag attendance. If I manipulate the sheet using AutoFilter
to show only enrolled, canceled, waitlisted, etc., the check boxes behave as
expected and stay in their respective rows. If I do a sort, however, the
boxes keep their relative positions and don't go along for the ride with the
surroundi...
|
1 |
25.09.2006 16:29:02 |
|
|
cant find excel in my office xp (2002)and how to install it?
well in my programs>office10> and i cant see excel in it or even access, so
what do i have to do to get them to work?
...
|
2 |
25.09.2006 16:06:02 |
|
|
Copy formula automatically down when date is entered
I would like to apply a formula to the entire column, but this
increases the size of the spreadsheet and also is a bit messy when
printing.
When I enter data into B5 for example, I would like C5 to automatically
enter the vlookup formula I have written.
Any Visual basic commands I could try?
Thanks again guys for your help
...
|
11 |
25.09.2006 15:54:03 |
|
|
cannot create templates in spreadsheet solutions tab in excel
Contrary to the Excel 2000 help I am unable to create templates in the
"spreadsheet solutions" tab of the File New dialog box nor can I create new
tabs by making sub-folders in the direcctory where the built-in templates
reside ie "C:\Program Files\Microsoft Office 2000\Templates\1033". I can
create template entries in the General tab by placing them in the
"C:\Documents and Settings\use...
|
2 |
25.09.2006 15:52:11 |
|
|
Hyperlink Macro
How do I create a macro to do what the right click on "Hyperlink" does? This
way I won't have to click on the whole path to my server files every time I
want to hyperlink. ...
|
1 |
25.09.2006 15:51:02 |
|
|
hyperlinks no longer working
Hi All,
Got a problem with hyperlinks in Excel - set up a worksheet years ago to
keep track of enquireies for work - started using hyperlinks to open up the
folder on the network where all the drawings, word-docs, excel-sheets, etc.
were kept.
Since updating Windows XP to SP2 the hyperlinks no longer work - even new
ones i create don't work. have tried updating from Excel '02 to Excel '0...
|
1 |
25.09.2006 15:50:02 |
|
|
How do I copy formulas from 1 wrkbk to another w/o absolute refs
I am trying to copy a summary from one workbok to another. How do I copy
with out absoute references to the source workbook?...
|
2 |
25.09.2006 15:48:55 |
|
|
merged cells don't center over columns to repeat at left
I have multiple pages in my spreadsheet. I have the first column (A)
repeating on each page. I have text I am using as a title on each page. To
create each title I typed my text into the first column on that page and
merged all the cells in that row. I centered the text in the new merged
cell. Normally this creates a title centered on my page. However, when I am
repeating a column ...
|
1 |
25.09.2006 15:39:02 |
|
|
help on UDF code
I have the following code to create a UDF to calculate reciprocals:
Function Reciprocal(a)
Reciprocal(a) = (1 / a)
End Function
The code is in a module.
I get #VALUE! errors when I try to run it. So I think this means that Excel
recognizes the UDF (otherwise it would return a #NAME error, right?)
So what's the problem here?
--
Brevity is the soul of wit....
|
4 |
25.09.2006 15:34:03 |
|
|
Automatic Auto Fill
Is there a way to automotically auto fill formulas down a column when the
data next to it extends? I have data in columns to the left that will
periodically get longer and I want the formulas next to the data to extend
with the data automatically after I refresh the data query (from microsoft
query)....
|
1 |
25.09.2006 15:23:03 |
|
|
Alt+Tab doesn't work to change from excel file to excel file
What do I do to be able to change from one excel file to another excel file,
the Alt+Tab is not working....
|
2 |
25.09.2006 15:12:09 |
|
|
Using a function
Hi,
I want a function to return a value, but it is not working. Here is my code.
Sub NewTest()
v = 1: j = 9
x = TestFunction(v, j)
End Sub
Sub TestFunction(x, y)
TestFunction = x ^ 2 + y
End Sub
Error Message = "compile error, expected function or variable",
highligted --> "x = TestFunction(v, j)"
Does anyone know how to fix this?
Thanks for your...
|
3 |
25.09.2006 15:08:01 |
|
|
always present input form
I have a spreadsheet with 10 output sheets. The output changes
depending upon which product is being analyzed, which is set in a
product input cell on the summary sheet. I would like to be able to
change the product from any of the 10 output sheets. Any suggestions
on how to go about this? I don't like having to flip back to the
summary page everytime I want to change products and I prefe...
|
1 |
25.09.2006 14:55:25 |
|
|
formula
sheet 1 is my data as given below
A B C
D
AMOUNT DATE CUSTOMER NAME
COLLECTION BOY
200 1/1/06 ANIL
SUNIL
200 1/1/06 AMIT
SHANKAR
200 2/1/06 ...
|
4 |
25.09.2006 14:50:33 |
|
|
Titles in column A appear on every page printed help
I have a document 10 pages long.
In column A I have a list of titles.
When I print I would like column A to appear on all 10 pages. Is there
a way I can set column A to be a repeater on all pages to follow?
I hope this makes sense.
...
|
2 |
25.09.2006 14:44:11 |
|
|
Recovery of a password-protected excel 2003 file
Hi.
I have a password protected excel 2003 file (with known password) that
used to reside on a file server and was being updated by a number of
people every day. At some point it became corupt and no-one can now
open it. When I try to open it, it pops up the message: "...The file
may be read-only, or you may be trying to access a read-only location
or, server the document is stored on may b...
|
1 |
25.09.2006 14:40:01 |
|
|
Office 2003 Send To option of mail as attachment
What happended to the "Send To" option of "mail as attachment" that I used to
have in previous versions of Office?...
|
2 |
25.09.2006 14:03:21 |
|
|
Shade partial cell
Any ideas on how I can shade the bottom half only of a cell? The cell needs
to contain a two digit number but only show the bottom half as being shaded.
Thanks for the help.
LJob...
|
2 |
25.09.2006 14:01:03 |