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 / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
table within cell24 Apr 2007 22:08 GMT1
Can a table be placed inside a cell?
           A                             B                               C
1        cat                          mouse                         horse
2        dog                            A     B     C               pig
Excel prints page as tiny little square24 Apr 2007 21:18 GMT3
Someone sent me an Excel spreadsheet and half of the tabs are ok, but
half print as a tiny one-inch square somewhere on the page.
How do I fix this?
P -
concatenate data problem24 Apr 2007 20:30 GMT3
I have the following formula
=CONCATENATE(B13,AY13,"-",C13,"-",D13,"-",E13,IF(F13="","","-"&G13&AY13&"/"&F13))
to return the following text
2.5"-MS-1302-01CS-1SW-2.5"/ST
Mapping network drive...24 Apr 2007 20:21 GMT2
Is there a way to map a network drive in a macro?
running some VBA code in response to data entered in a cell24 Apr 2007 19:50 GMT2
hello again
Can anyone tell me if it is possible to trigger some VBA code when a number
entered in a particular cell on a worksheet is less than the number in
another cell?. I dont know if cells have events linked to them such as mouse
Toolbars with diff versions of Excel24 Apr 2007 19:20 GMT7
I have a customized toolbar in Excel 2003 and want to use the same
customization in Excel 2000 without ahving to do everything rom scratch. Is
the 2003 XLB file compatible with the Excel 2000. Or is there a way to
export/import between versions?
File opening help24 Apr 2007 18:58 GMT4
I have 2 files that I created last week (spent a lot of time on them also)
and for some reason they wont open.  Excel asks if I want to update links and
then doesnt do anything.  It looks like the file is open as when I go into
explorer I cant move it - but in excel its just not ...
Conditional Format24 Apr 2007 18:28 GMT2
I have one column that contains condtional formatting as the following:
=today()-D2>=90
Should the field meet the above condition then the text would turn red as
the format but even though it was applied to the entire column, each date
Help with entering text in a macro.24 Apr 2007 16:52 GMT4
As part of an existing macro I want to add quite a lot of text in rows 1 to 13.
The way I am achieving this is using:-
ActiveSheet.Cells(1, 1).Value = "insert text here to appear in row 1 column
1, the value of cell A15 is”
Conditional formatting, "0" not equal to blank24 Apr 2007 16:41 GMT3
I would like the following conditional formatting
A blank cell = no filling
0 to 0.99 = red
1 to 1.99 = yellow
Find & replace on multiple worksheets24 Apr 2007 16:22 GMT5
I have multiple worksheets in my file.  How can I use find and replace over
all of them instead of going into each individual worksheet?
Thanks much!
how to look up the value in another sheet24 Apr 2007 14:54 GMT1
I have one input sheet use to add data to another sheet(Database). The
input sheet is like a checklist.
In the input sheet, I have one combox box to select the tool id.
Since each tool will have its own spec for each inspection (upper
video24 Apr 2007 14:11 GMT4
I'm not sure if  I'm posting in the right place...anyway.
When I want to watch a streaming video the video will pause, I assume to
allow more data to be "loaded". How can I avoid that. I wouldn't mind
waiting as long as I can view the entire video without a pause.
How to start a macro with pivot-chart-update-button (!)24 Apr 2007 13:45 GMT4
Hey Guys
The pivot-chart-update-button (!) dominates my custom pivot-chart-
layout. This annoys me (and I get no credit from my colleges as Excel-
expert). The chart is placed in a chart-sheet.
IsNumeric with array or range24 Apr 2007 13:29 GMT4
I want to check a list of cells to be sure they're all numbers before
performing a computation on them.  Is there a quick way (as opposed to
looping through all the cells) to check?  I could set the cells up as either
an array or range but IsNumeric doesn't seem to work on either ...
 
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.