|
If-Then-Else Statement
It is not executing my If-Then-Else statement.
It seems the only statement being executed is: Cells(Row, Col).Value =
Range("K" & Row) and I only want it to do that if the condition is
true, and put a 0 in each cell in the range if it is false. Can someone
please look at my code and help me to get it to execute the
If-Then-Else statement. Thank you. Updated code as follows:
Sub Fill(...
|
3 |
05.09.2006 19:16:20 |
|
|
subpie from pie
Hi, dear group!
Everytime whenever I try to create a subpiechart from a pie-piece I get it
wrong!
Is there a special way of selecting the cells before you make the nested pie
or has it to do with the way you organize the cells in your sheet.
I sure would gladly accept just the one way to overcome my stupid problem.
Any help is greatly appreciated.
Thanks
Hermann
...
|
2 |
05.09.2006 18:59:24 |
|
|
Excel displays incorrect values when exporting Access report with
I am suffering from a problem that Microsoft is aware of and wrote this KB
artible: "Excel displays incorrect values when you export an Access report
with numbers"
http://support.microsoft.com/kb/823222/en-us
Anyone know if this KB article has been resolved yet?
...
|
1 |
05.09.2006 17:51:02 |
|
|
Gridlines problem Excel 2000
I am trying to print gridlines on a workbook and instead of getting the
gridlines, I am getting a line around the outside of the data, like a text
box frame. I have been using gridlines for quite a long time and never came
across this before. I tried turning the lines off and back on, still the
same, checked the cell formatting, no border is enabled or anything. Anyone
have any ideas?
...
|
5 |
05.09.2006 17:22:27 |
|
|
Code returns TRUE instead of value
Essentially what I am trying to do is this:
I am trying to calculate depreciation.
I use the DateAdd function to add x number of months(Cell "F & Row that
is active") to the acquisition date(Cell "H & Row that is active" of
an asset.
If the sum of those dates is greater than the End of life (Cell "I &
Row that is active") of that asset then there is a payment for that
month and the ...
|
3 |
05.09.2006 16:20:49 |
|
|
Excel is not working!
I open excel. As soon as I moe the mouse to any cell the mouse sticks ther
and gabs cells. I must close excel. What is up?
--
t...
|
4 |
05.09.2006 15:49:52 |
|
|
Trying to change a formula
This is the formula I am using and it works good....
=SUM(IF(ISERR(FIND("-",G15:G125)),,REPLACE(G15:G125,1,FIND("-",G15:G125),"")-LEFT(G15:G125,FIND("-",G15:G125)-1)+1))
I now need to extend down to cell G133 instead of G125
I have manually changed all the G125s to G133 but then it returns a zero
What am I doing wrong?
thanks
--
...
|
5 |
05.09.2006 13:32:29 |
|
|
Enable Macro Message
How can you disable the message upon opening a file without setting the
security to lowest? I do not want to give the user options to disable or
enable the macro.
Is that possible?
Thanks....
|
2 |
05.09.2006 12:20:33 |
|
|
Make the #N/A invisible
I have specified some formula in my Excel worksheets. But, when the
cells are empty(with no data), it shows this sign #N/A in the cells.
How I could make it invisible so that when a user print the sheet, it
will only display the cells that contain data?
...
|
5 |
05.09.2006 09:15:01 |
|
|
Counting Entries across a row
Hi,
I have a spreadsheet with 12,000 rows of data.
Each row has data on the product and country it is sold.
The columns are basically labeled:
Product Name Argentina Austria Brazil Belgium....and so on....
There are 50 column headers (One for each country our products are sold
in!).
I need to count how many countrys each product is sold in...
Unfortunately, where there is a ...
|
4 |
05.09.2006 08:43:32 |
|
|
2 Part Question
Hi,
I'm looking to be able to type 2 lines of text in a single cell. Each time I
press "enter" my cursor goes to the next cell. Is there a way to do this.
Next. I'm trying to create a reservation book for my restaurant. I have the
form all setup the way I like it but I was wondering if there is a way to
set the date in a cell so that when I print each page will have a different
date....
|
2 |
05.09.2006 06:42:40 |
|
|
How can I display and print more than 1024 characters in a cell?
I have Excel 2003 and would like to print with more than 1024 characters in a
cell. Currently any characters beyond the 1024 characters are not displayed
under the 'wrap text' function.
Thank-you...
|
2 |
05.09.2006 06:36:05 |
|
|
Excel97 SR-1 problem
Don't know what key I clicked but when I try to add 6.36 to a cell I get
1/6/1900 in that cell instead after hitting Enter. In the formula bar above,
I guess; the value is 4.27. Just adding up expenses in a single column,
nothing tricky. Thanks, Steve T.
...
|
4 |
05.09.2006 05:44:11 |
|
|
Focus on Excel windows when it runs in IE
Hello all,
I am facing one problem related to focus of Excel windows.
I am opening excel in IE. It has 'Save' button to save file. when only
one file is open then everythig goes fine.The focus remains on the same
Excel window. But when i open several Excel files in same IE and click
'Save' button,then the file is saved but focus is lost now. I can
switch between excel windows but none o...
|
1 |
05.09.2006 05:33:43 |
|
|
Focus on Excel windows when it runs in IE
Hello all,
I am facing one problem related to focus of Excel windows.
I am opening excel in IE. It has 'Save' button to save file. when only
one file is open then everythig goes fine.The focus remains on the same
Excel window. But when i open several Excel files in same IE and click
'Save' button,then the file is saved but focus is lost now. I can
switch between excel windows but none o...
|
1 |
05.09.2006 05:33:38 |
|
|
Install FrontPage for excel?
Hi. Lucky me...first post on this forum but thanks in advance if you can help.
I recently performed an update. Since today I notice all programs seem to
open without problem except for excel. It wants me to insall excel with
frontpage before opening. Naturally it does not open and I don't have a CD
with frontpage. What shall I do? How can I redirect all existing documents
to excel w...
|
3 |
05.09.2006 01:56:17 |
|
|
Picture number
How can I know the picture number in a specific cell? I would like to
pass the info to the
ActiveSheet.Shapes("Picture xx").Select
Thank's ahead
...
|
12 |
05.09.2006 00:24:42 |
|
|
Combine rows based on values in column 1
Is there an excel feature that would let you combine rows based on the
unique value of a column? The DATA, SUBTOTAL almost does what I want,
except it doesn't work with text. For example:
A X
B Y
C Z
A X
C Z
C J
B M
Combine to:
A X X
B M Y
C Z J Z
I can write a routine that will do t...
|
2 |
04.09.2006 20:07:07 |
|
|
textbox format
Is it possible to format the text, eg. date (mm-dd-yyyy), in textbox of
control toolbox? ...
|
4 |
04.09.2006 09:15:31 |
|
|
Trust all access for visual basic project
Hi everybody,
I just can't find how to check the checkbox in tools\macro\security\trusted
publishers
The checkbox is grey and cannot be enabled.
Someone can help me please?
Thank you in advance
PS sorry for my poor english :-)
have a nice w-e
...
|
3 |
04.09.2006 08:45:05 |
|
|
Points with the same value lie on top of each other - displace, move
This question was asked a few years ago by someone else:
http://groups.google.co.uk/group/microsoft.public.excel.charting/msg/...
Basically, I am using a line chart for a 'wrong' purpose. X axis values
are actually categories and data points are not joined by lines. I am
doing this to produce a chart such as this:
http://conceptwheel.servehttp.com/chart.gif .
The answer given in the pr...
|
1 |
04.09.2006 04:30:14 |
|
|
Finding the percent of Yes answers pt 2
The initial formula, =COUNTIF(H4:H33,"Yes")/COUNTA(H4:H33), works great.
But, no let's say that besides Yes and No answeres, there are n/a answers.
How do I account for this in the formula.
Excel XP SP2
...
|
2 |
04.09.2006 01:43:01 |
|
|
Help - Finding the percent of Yes answers
I have an 80 line column with Yes/No answers (Y=yes and N=no), and I need to
find the percentage that were marked Yes. For example, let's say there are
63 Yes and 17 No answers. That would be 78.75% were marked as Yes.
Excel XP SP2
--
...
|
6 |
04.09.2006 00:56:48 |
|
|
Calculation problem where a fixed charge is involved
Forgive me for asking guidance on something which is probably quite simple.
I've set up a worksheet to calculate all the hidden costs of on-line
auctions and it is the PayPal aspect that is giving me grief.
PayPal charge me 3.4% + 20p per transaction. If I use:
=SUM(B2*0.034+0.2)and C2 and D2 and so on...
....it obviously gives me the right answer but, if I just enter the
formula a...
|
7 |
03.09.2006 23:25:05 |
|
|
Count fields and show 1 or 0
OK guys, I have another problem I will post here and on another post if
nobody reads this.
I have the same 5 (A2:E2)fields, each with a 1 or 0. What I need this
time is that If A2 is 1, then I need A2 plus any 2 (1or true) of the
remaining four (B2:E2), to them have the new field box called total to
read 1 or true. If A2 is 0(false), then regardless of the other four,
the Total field must ...
|
3 |
03.09.2006 21:31:21 |