Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Calculation speed27 Sep 2006 12:15 GMT3
I have a not hugely complex workbook which I have been running without fuss.
Now, on machines upgraded to use Excel 2003, every time you enter a new piece
of info it takes up to a minute to calculate whilst the same file is fine on
the previous version of Excel. I can turn the ...
Select range in VBA through variabel27 Sep 2006 11:58 GMT2
Hi I try this code, but I will not work.
sub selectnamedrange(fblock as Integer)
   dim frow_string
   frow_string = "f" & fblock & "_frow"
Converting A Word Table To Excel27 Sep 2006 10:46 GMT1
Hello to all -
Is it possible to convert a table created in Word to an Excel spreadsheet?
If so, please advise.
I have a form that I created in Word that I would like to convert into an
Add text to bar charts27 Sep 2006 10:13 GMT3
have a series of bar charts want to add text to these, can anybody
help?
The text that I want to add is the same as the legend if that helps
thanks in advance
Date and Text combination27 Sep 2006 09:17 GMT3
could someone help me with getting this particular format in ONE SINGLE
cell:
Text 25-Sep
Please note that the date part has to be variable, i.e i shuld be able
Macro to set the row height27 Sep 2006 08:52 GMT1
I need to set the row height depending on the content of a cell.
If Cell A1 = "x", I want to set rowheight of A to 50, if A1 = y , then I
want to set rowheight of A to 75
I want to repeat this check for 100 rows.
FALSE Statement27 Sep 2006 08:33 GMT2
I have a formula like this
K232=IF((J232="A"),-1*I232,IF((J232="B"),I232*F232,IF((J232="C"),0))
If there is nothing on J232 it displays FALSE , I would like to get rid
off this FALSE and cell should be blank, i tried IF(J232=""),""  but
Formula - Exam Marksheet27 Sep 2006 07:51 GMT9
Please help me with a formula for my marksheet.
The exam grading is A, B, C, D and E.  E is a failure
To pass the overall exam, a student must :-
Must NOT FAIL in any 4 subjects from columns E7, G7, I7 and K7
Recent File List not there27 Sep 2006 02:29 GMT7
In Office Pro/Excel 2000 I have Options set to show the last 9
files used, but lately there have been none showing if I haven't opened
Excel for more than a day or two.  I never heard of this being time
delimited before.  Any suggestions?
What is the best work sheet used to calculate monthly expenses?26 Sep 2006 23:13 GMT1
I would like to compare salary against monthly expenses and would like to
know if there is such a template available.
Pivot Table Subtotal of Calculated Field Problem26 Sep 2006 22:39 GMT3
I have created a pivot table for the purpose of viewing revenues by
sales person, company and project.  I am having a problem with the
subtotals due to my use of a calcuated field.  PLEASE HELP!!  Here is
the info:
Conditional formatting question?26 Sep 2006 21:09 GMT3
I tried to set two conditional formats across the same range of cells using
Format >> Conditional Formatting.  I tried to set Formula Is =MAX(U5:AB5),
font = red, and Formula Is =MIN(U5:AB5), font = green.  The font in all
cells turned red!  What would be the correct way to do ...
X Y position26 Sep 2006 19:55 GMT2
Can someone confirm that the figures at the end of the code below, relate to
the position of where the input box will appear on the screen?
I then need to be able to explain to a non techie how that relates to a
screen.
If Statement26 Sep 2006 19:25 GMT3
Hi  In an If styatement, how would I go about testing to see if a cell
contained a text string please
- If (E2="*Phone","True","False"), which is what I assumed the syntax was,
doesm't work
More than one line in a single cell?26 Sep 2006 18:47 GMT1
How do I enter multiple lines in a single cell in a column?  I need more than
one line of information to fit it all in a cell of a row in a column. Please
help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.