|
|
Show zero in a cell by
Clare
Hi
I have the undernoted formula, however, when cell H3 has no date in it the
cell with the formula shows 5714 can anyone tell me how to make the cell show...
( 1 2)
|
|
10 |
305 |
|
|
Evaluating formula in VBA by
Walter Briscoe
I have a string variable containing a formula which I want to evaluate.
I can do what I want with
activeCell.FormulaLocal = fx
result = activeCell.Value
I...
|
|
5 |
305 |
|
|
"Fill" command by
Lin Kypta
I am an experienced builder of spreadsheets, but I am new to Excel 2007 in a
VISTA system. The problem: I can't find the "fill" command and since it is...
|
January 4th, 2010 02:19 PM
by Somona
|
4 |
305 |
|
|
Protect Workbook Vs Protect Sheet by
Poor_pakistani
Hiii hope u are all ok. i have a problem about protect workbook.when i go to
tools menus and then point to Protection and click on the protect work book
to...
|
|
4 |
304 |
|
|
|
|
0 |
304 |
|
|
lost gridlines by
Joanne
Why do I lose my gridlines when I apply background color to a block of
rows? And why do I not get them back when I change the color back to the
usual white...
|
January 19th, 2008 04:44 PM
by Joanne
|
3 |
304 |
|
|
Problem with VLOOKUP Results. by
Greg
My issue is:
Col A has the airport codes (ABE) and my table array has the airport codes
decoded.
The formula I used:
=VLOOKUP($A$2:$A$2544,'AIRPORT...
( 1 2)
|
June 2nd, 2008 11:00 PM
by Greg
|
10 |
304 |
|
|
Validation data by
P.george
i want to do a list so that users can pick from the list what price they want i have solved this with validation data but in the
drop down list users see the...
|
June 1st, 2004 11:11 PM
by CLR
|
1 |
304 |
|
|
Full path possible to be seen? by
Octavio
Where to set Excell so the Excell window and file that I am working with
shows the full path (full path.xls) of where the folders are in the upper
left hand...
( 1 2)
|
|
10 |
304 |
|
|
|
October 26th, 2007 03:16 PM
by slow386
|
2 |
303 |
|
|
|
July 24th, 2006 01:53 PM
by Marcelo
|
1 |
303 |
|
|
macro disabled by
Mo. bannayan
Hi there;
well I got a file from a friend which contains a macro, but when I open it a
message pop in as the macro is disabled and I should change the...
|
|
2 |
303 |
|
|
Overline or Overbar Font by
Etienne Erasmus
With reference to my previous question regarding a line on the top of text.
How can I create an overline font which is similar to the underline font,
except...
|
|
3 |
303 |
|
|
Currency Conversion formula by
Mel Garcia via OfficeKB.com
I need anyones help.. I need a formula that converts the Pound to us
dollars and another one that converts us dollars to pound.
Can anyone help...
|
|
2 |
303 |
|
|
Moving cursor to next open cell by
Wolf
What command do I need to type to move the cursor one cell down? I have
created a macro that copies an entire line of data to a spreadsheet by going
to a...
|
December 16th, 2004 09:59 PM
by Paul B
|
3 |
303 |
|
|
|
June 11th, 2004 08:24 PM
by Bill
|
7 |
303 |
|
|
picture by
raismisuaween
picture of
picture
pictures of peace
pictures of
pictures
|
|
0 |
303 |
|
|
Paste Multiple items by
AJM1949
Currently I use a macro to highlight the selected row on a Price List and
then a 2nd macro (different macros for pricing levels) to paste selected info
from...
|
June 23rd, 2005 12:48 AM
by AJM1949
|
8 |
302 |
|
|
help on a macro by
gls858
I recorded macro that imports a text file and adds headers
to the columns. When I run the macro it opens a new workbook
and inserts the text file.
Is is...
( 1 2)
|
March 18th, 2005 11:56 PM
by gls858
|
15 |
302 |
|
|
Random Number by
Dan Tschippert
I am trying to make a spreadsheet that would randomly select and record a 3
digit number on demand.
I want to use this for drawings to replace a lottery type...
|
|
1 |
302 |