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 / General Excel Questions / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Find a character in a textstring28 Sep 2006 17:56 GMT2
I would like to find a character (in my case the letter S) in a list of
textstrings,
and then return the textstrings containing "S" , as well as the two other
columns that correspond to it .
Excel + user input + external data (URL manipulation)28 Sep 2006 17:48 GMT2
Is there any way for excel to manipulate the values sent with the
external data (URL) request?
Here's the basic concept:
- User opens survey excel file on their desktop.
duplicate text28 Sep 2006 17:37 GMT4
How do you find duplicate text entries using conditional formatting?  All
information is geared towards number format.
I have names (all in one col) that I would like to find out if they are
duplicated...
Excell 200328 Sep 2006 17:22 GMT1
[1] How does one show negative numbers in red color?
[2] How does one "paint" cells/fields?
Merged Cells in Worksheet, Test for28 Sep 2006 17:09 GMT2
XL 2003
Simple way to test for existence of any merged cells in worksheet.
Must it be a cell by cell evaluation OR  [Each myCell in myRange]
is there a "merged state"  that is reflected on a Sheet basis?
Macro prompt28 Sep 2006 17:03 GMT2
I have a macro that creates a new worksheet, deletes 2 tabs, then closes the
worksheet.
When I run the macro there are 2 prompts,
1-do you want to delete the sheets
uppercase28 Sep 2006 16:59 GMT1
is there a way to convert all data in a range to uppercase and also
make it so all future entries are in uppercase?
An if question28 Sep 2006 16:53 GMT2
Hi I have in a row 3 different values that I want to compare with a specific
value on the same row. It looks like below
A    B     C      D
10  20   30     22
Excel workbook is corrupted, workbook automatically saves on start28 Sep 2006 16:51 GMT3
I have a group of users whos speadsheets seem to get corrupted quite often.
The offending sheets cannot be opened in excel, it hangs at the start of
opening the file,cpu goes upto 100% and just sits there almost like its in a
loop.
Password a Macro so certain users can press it28 Sep 2006 16:44 GMT2
I have a cell on my worksheet which is protected via the usual password
protect worsheet thing. However, i want to allow one person to write in
this cell my pressing a macro which allows him to do this, then lock
again after if possible? Anyone any ideas?
How do I turn off the automatic Format Painter?28 Sep 2006 16:36 GMT2
This stupid little "PaintBrush" keeps popping up and blocking the cells I am
trying to work with.  
It is more annoying than the "automatic" mulitple copy clipboard because it
actually sits on top of what I am working with, blocking it from my view.
Dropdown from a Dropdown28 Sep 2006 16:00 GMT1
I am trying to create a dropdown menu that is dependent on another dropdown
that I have already created.
The simplest way I can think to illustrate this is to give the following
example:
Bulk change cells to Array Formula28 Sep 2006 15:59 GMT1
I have a sheet with several hundred cells which are filled with array
forumlas.  The problem is that none of the formulas have been entered
by using CRTL-SHIFT-ENTER.  Does anyone know of a VBA function which
can be used to set all of these cells to Array forumlas?
How do print only the used portion of an excel spreadsheet?28 Sep 2006 15:55 GMT1
Unless I request printing a specific number on pages only, my printer will
print 1200 pages, even thought my file is only 5 pages long.
Formatting a formula within a cell28 Sep 2006 15:49 GMT4
I am trying to use a formula and text within the same cell but I want the
value of the formula to have a currency format.  Can this be done?
I have even tried to use a separate sell to calculate the formula to give me
a currency value and then input the value of the cell into the ...
 
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.