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 / August 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Recover deleted excel-files on usb-stick31 Aug 2008 22:45 GMT9
I accidently deleted an usb-stick with lots of important excel-files. Has
anyone by experience managed to undelete and recover them and cab give me the
name of an undelete/recover program. I already tried a lot of them, but none
of them did the job (or seems to can do the job for ...
"Not Responding" for HOURS31 Aug 2008 21:14 GMT1
My Excel 2007 spreadsheet has been "Not Responding" for HOURS.
I can hear the hard drive spinning (at various speeds) but, on the PC,
the green activity light (indicating that data is being written to or
read from the hard drive) has been flashing very infrequently.
AVERAGE formula with a twist31 Aug 2008 20:29 GMT5
I need to average a range of cells B2:Y31.  Normally, I'd use the formula
=AVERAGE(B2:Y31)... easy enough.
The twist is that I need to average that range of cells, BUT any cell that
has a value less than 1 or more than 900 cannot be used in the calculation.
List of worksheets31 Aug 2008 19:01 GMT9
In a workbook with multiple worksheets, each with a unique name, how would I
create a list of of the worksheets?  In addition, I'd like to be able to show
totals from each sheet beside the sheet's name.
Can I make gray scale charts?31 Aug 2008 17:26 GMT1
I have a series of pie charts and bar charts.  Is there anyway to get them
in black and white instead of color?
Formula prob - or is it validation?31 Aug 2008 16:39 GMT6
In cell A1 I have created a list with options - 1st quarter results, 2nd
quarter results, 3rd quarter results, 4th quarter results.
Cells A2, A3 & A4 are for the months of the quarter.
If I select "1st quarter in A1", I want A2 to read "Jan", A3 to read "Feb",
Starting Excel Impossible31 Aug 2008 16:06 GMT2
It is impossible to open Excel, because of this message:
In a Message Box "Microsoft Visual Basic", it is said: "System Error
&H80004005 (-2147467259). Unspecified Error"
What can I do?
Euro symbol31 Aug 2008 12:51 GMT5
I have a spreadsheet and I have formatted the cells to give me the euro
symbol (previously uk sterling) so that is ok.
However within the spreadsheet I have a text box, how do I get the euro
symbol within it?
Date in CAPS31 Aug 2008 04:28 GMT3
I've got a cell with a date that the user types in.  Currently, the
user types a date in and it automatically changes the format to
DDMMMYYYY.
I need the MMM to be in all caps so that it feeds a SQL string
Select All question31 Aug 2008 03:53 GMT4
At home I have Excel 2002 and am very happy with it. At work, I have
Excel 2003, and I find it disconcerting that, when I hit a Ctrl + A, it
selects a range of its own choosing, within the work I am most currently
on. When I say Select All, I mean Select All - is there some ...
Compare columns31 Aug 2008 03:46 GMT2
How do I determine whether the data in COL A exists COL B?
How do I determine whether the data in COL A does NOT exist in COL B?
how to fix starting point when counting rows?30 Aug 2008 20:37 GMT4
is there a way to feed in the the starting cell to begin from when
counting the number of rows?
i can get the below to work in a macro
Dim countRows
Date Format30 Aug 2008 19:42 GMT5
I would like to convert a date that I've input from another program.  When I
input it I get 'Aug-28-2008.  I want it to just be a regular date - so it
would be *8/28/2008 if I were to select it in Format Cells.  
It says that I have General as the Category selected.  When I switch ...
VBA;  Escaping a 'For  Next' loop question30 Aug 2008 19:24 GMT8
   I have some code which uses a For Next loop which works very well
with a very large set of 'Regular Expression' statements.
   I'm sure when the code is run, it would be a bit quicker if it
could go back to 'For' when the value of 'valid' is True rather than
Exclusion List for Data Validation??30 Aug 2008 18:07 GMT1
I have cells that require an entry (last names of people), so I have
the validation set up for text >1 and <1000.
This is good if the user decides to leave it blank, but if they put in
a space, or two spaces, or more, or put in words like "none" "N/A"
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.