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 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
latest date19 Sep 2007 13:09 GMT5
help need
hi
i have a list of disconnection customer. in that list the disconnection date
is repeated. means disconnection is made more than 2 time. it is difficult to
Setting up an If-Then condition off of a command box19 Sep 2007 10:22 GMT1
I am trying to set up a command box that will do two things conditionally if
clicked.  First, I want to run a macro that will validate that text is
present in a range of cells (all cells must have text values, although the
text values may vary).  If all of the cells in the range ...
rngDataAll, rngEnd, rngStart, etc19 Sep 2007 09:06 GMT3
I have come across these values rngDataAll, rngEnd, rngStart, etc used
with a range object thus:
  Range("rngEnd")
It is self-evident what they mean but where are they defined?
Spreadsheet of seven types of items19 Sep 2007 08:11 GMT1
The first item will be the date.
The second item will be purpose in text.
The third, fourth, fifth, and sixth items will be numerical data.
The seventh item will be numerical data.
Getting a pictures height, width before setting it in Shapes.AddPicture19 Sep 2007 05:54 GMT1
I'm inserting several images into a worksheet however these images are
rather large.
Therefore rather than doing
Worksheets(1).Range("A1").Select()
Changing this formula?19 Sep 2007 02:04 GMT8
=IF(L2<>"",IF(M2=0,"OKAY!",IF(M2<>0,"RE-VERITY (or M1 needs a value in
it!)!!!","")),"")
I'm stuck and am probably going 'round in loops, but I need to add one more
condition.  If L2 is blank, there needs to be no text.
Splitting one cell into three.19 Sep 2007 00:23 GMT2
Try to split a cell in Excel 2000.
in one excel cell the following information is recorded.
.032 x 6 x 12.5 2024-t3 clad
If I can pull out  the information .032, 6, and 12.5 to three separate
Position in a list of numbers19 Sep 2007 00:16 GMT3
Hello, I hope someone can help me.
Is there a function (or a combination of function) to let me know in
which position of a list is a specific number?
For example, I have this list of numbers
Excel 2007 crash on save18 Sep 2007 22:46 GMT6
I have several users, albeit not all, who are experiencing problems with
Excel 2007 crashing during a manual save.  Windows XP on all machines.  So
far it is only desktops, so the Bluetooth Com+ add-in is not an issue.
These are spreadsheets that were created in Office 2003, so ...
How can you make cells bold or shaded no matter what gets moved into it?18 Sep 2007 20:10 GMT2
I have a few different cells in my Excel spreadsheet that I want to always
be bold or shaded red no matter what is in these cells. I have some data
that I sort and always want the top to be bold and shaded red. And of course
when I sort the data and the top data that was bold and ...
Limiting Decimal Entry18 Sep 2007 19:25 GMT5
Does anyone know if there is a way for me to limit the number of decimals
entered into a cell to 2?  I don't want to truncate or round the entries.
It doesn't matter if an error message is raised, I just want to set a hard
limit.
data validation box arrow18 Sep 2007 19:25 GMT2
Excel 2002 SP3
Win XP HE
Hi,
On a data validation cell using the drop down list, is it possible to
Difficult formula...18 Sep 2007 19:22 GMT2
I'm having a heckuva time figuring out a formula. There's gotta be an easy
way to do this. Here's my data:
==================================================
    A    B      C            D
I need a list of my tabs!18 Sep 2007 19:10 GMT2
I have a project in Excel that has about 300 tabs.  Is there a way that I can
get a list of the tabs only?
Signature

~Christina

"screen shot" of formula results.18 Sep 2007 18:56 GMT2
I'd like to "unlink" a spreadsheet from the formula's.  I have a spreadsheet
that references other spreadsheets but I'd like to break all the links at
once.  Is there a way to do this?
 
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.