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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Adding a loop to conditional delete code15 Aug 2006 16:11 GMT21
I have the following code:
Sub DelOver16()
If ActiveCell.Value >= 16 Then ActiveCell.EntireRow.Delete
End Sub
Excel chart with two x-axes15 Aug 2006 13:15 GMT2
I would like to draw a chart with one y-axis and two x-axes.  Please can
someone point me in the right direction?
:)
No Color Palette, ActiveX15 Aug 2006 13:10 GMT1
I have placed a CommandButton on a worksheet  from the "Control ToolBox"
tool bar.   When I right click on the CommandButtom and select "Properties"
and get the properties Dialog box to appear. I next select "BackColor" , so
I can change the background color of the CommandButton. ...
Basic hours * rate formula15 Aug 2006 12:52 GMT1
Sorry for this lame post.....
I've a cell showing the amount of hours spent on a project (68:45:00).
My hourly rate is $ 105
How do I convert the hours into a number which I can then multiply with 105
cannot scrol on huge spreadsheet - urgent15 Aug 2006 12:20 GMT2
i have excel 2003. some of our staff is working on a membership database.
all this info is in a spreadsheet. it is lots of info. thousands of records.
there is custom filters in the different columns. lets say they choose CTE
from the drop-down list than all the CTE records ...
Vlookup15 Aug 2006 12:13 GMT6
I have a vlookup sheet,I want to add notes to the cells in the vlookup
table,but when i get the information from the vlookup table to another sheet
the notes will not go over with the information .CAN ANYONE HELP.
P.S I hope i have explained this correctly.
Abridging lists of numbers15 Aug 2006 12:09 GMT2
I've a very long range of numbers  that I desperately need to condense into
a list that contains only ranges and single numbers, e.g. 1-5,6,8,11-32,35,40
Please help me out guys - the list is ridiculously long, and will take days
to do manually!!
How to know if a cell is in a range?15 Aug 2006 10:53 GMT2
I need to know if the cell D9 is in the range A7 - E20
Thanks
Worksheets Inheriting Contents15 Aug 2006 09:26 GMT2
I'm currently working on creating a set of specifications using Excel
These specifications are contained within a single Excel spreadshee
which contain multiple worksheets, each relating to a different aspec
of the form (say calculations, form rules, dependencies). The proble
Customization of paper size.....15 Aug 2006 09:01 GMT1
Hi goodmorning Everyone! hope someone can help me...i am trying to
figure out if i can customize the paper size options in the page set
up? is it possible? I am working right now with a continous paper with
5 x 8 inches measurement (portrait orientation)....thanks in advance!!!
Re: how to add one same word on every 10th line15 Aug 2006 08:54 GMT2
i have excel with 50000 lines.i have to insert  this  word
"###break###" on every 10 th line.how to do this?
i tried macro but cannot able to do.i need help.advance thanks for you
help
validation does not work15 Aug 2006 07:40 GMT2
If I input cell's value with VBA codes, the validation rules contained
in the cell would probably not work, are there any other ways to make
the validation works when I set its value outside the sheet?
Thanks,
Array Formula Help -IF / Else clause?15 Aug 2006 07:25 GMT4
I'm just getting to grips with Array formulae, and one of the formula I
use most frequently is to count combinations of values over two arrays:
For example:
=SUM(IF(A1:A100="Ford",IF(B1:B100="Focus"1,0)))
Data from multiple sheets and workbooks15 Aug 2006 06:51 GMT3
Each week I receive a workbook from one of my customers. It contains mutliple
sheets with salesnumbers from all the branch of my customer. Each sheet
contains from 1 000 to 15 000 lines of salesdata. Every article sold gets one
line in the sheets.
Hiding a cell from printing in Excel 200315 Aug 2006 05:47 GMT2
Is it possible to hide selected cells within a workbook from printing in
Excel 2003 and how can this be done?
Regards
Nevio
 
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.