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 / January 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Get first blank cell29 Jan 2005 21:27 GMT7
I would like to get the number of the row with a blank in a certain column.
I was trying something like this:
{=IF(ISBLANK(<range>),ROW(<range>),0)}
but that's not working. Can I do this without resorting to a macro?
Programming29 Jan 2005 21:17 GMT1
I have a problem.
I want to write a program using VB in Excel.
I put a txtbox and a cmdbutton in my worksheet. When I click on cmdButton, I
want my program to do this:
webQuery with stock quotes: single cell, not multiple cells29 Jan 2005 21:08 GMT4
Via Yahoo I am trying to get stock quotes into my Excel worksheet:
So via goto A1, select Data->Get External Data->New Web Query
and use e.g.
http://finance.yahoo.com/d/quotes.csv?s=EBAY&f=sl
Help with Diet29 Jan 2005 21:05 GMT3
I am on a diet and would like to make a spreadsheet to help track my
progress. I weigh in every morning and I now have about one month’s worth of
data, so I am anxious to get started – the problem is that I know almost
nothing about Excel.  I have bought a book, Show Me, which ...
need to import or convert Works.wdb file into Excel 200029 Jan 2005 21:01 GMT1
I need to import a Works.wdb file into Excel.  I have Office 2000 small
business.  I don't have Access.  Is there a way to open or convert this .wdb
file into Excel 2000?
Gordon. Yes f9 worked.How come not automaticly?29 Jan 2005 19:02 GMT1
Using Excel Spreadsheets My running sum at the bottem of page Changes
automaticly When I enter new numbers on some sheets but  I have to do it all
over on others.  Yes F9 worked but why is it not auto.  Y
Sub gives error I don't know how to fix....29 Jan 2005 16:46 GMT8
This sub, which gives a "Run-time error '13': Type mismatch", is meant to
put overtime for a 2-week period in the BB column, for all rows that have an
X in the AT column.  Hours for the 2 weeks are in AW and AX, and overtime is
anything over 40 for each week.  I cannot figure out ...
VB coding to clear a selection?29 Jan 2005 14:34 GMT8
I currently have the selection clear by changing the cursor location
to cell D2 (Range("D2").Select).  So if the entire sheet had all the
cells selected, this would clear the selection but would also move to
another location.  I actually need the active cell to remain the same
Finding sheets29 Jan 2005 14:30 GMT3
I'm just an inquisitive person, I guess ;-)
I would like to create the name of a particular sheet dynamically, then
read data from it. For example,
="'"&MONTH(A1)&"."&DAY(A1)&"."&TEXT(MOD(YEAR(A1),100),"00")&"-"&MONTH(B1)
How do I create a grading system in Office Excel?29 Jan 2005 14:29 GMT1
Many teachers use computers to build their grading policy and generate the
grades that their students get for each semester.  Can I do this in Excel?  
If so, how is this done?
Copy Formatting to new worksheet?29 Jan 2005 14:20 GMT1
I would suspect the answer to this is no but just by chance is there anyway
to copy all the formatting of a worksheet to a new worksheet without any of
the data.  Copy just colors, column widths, etc.  Would come in handy for
importing CSV data and then quickly formatting to a ...
How do I change office assistant in Excel 200229 Jan 2005 13:46 GMT1
How do I change office assistant in Excel 2002
Validation - help me pls29 Jan 2005 13:31 GMT3
With validation you get an arrow for a pull down, when you are standing in
the cell. If you not standing in this cell you do not know there is a
pulldown menu.
Does one of you know if it is possible that the arrow is shown everytime.
Can i run VB code when a user changes Worksheets within an Excel Workbook29 Jan 2005 13:20 GMT1
I have a Excel Spreadsheet with 6 worksheets in it
The first sheet contains all the data and the other sheets do various
things with the data (graphs etc)
On the first sheet i have buttons above some of the table colums which
velocity=Distance/time29 Jan 2005 13:11 GMT2
I want to obtain velocity of a vehicle by dividing distance(ordinary number
format) to time(time format of 00:00) by the formula: velocity=distance
(km)/Time(minute). And alternatively transfer it to Km/hour unit.
Divding numbers by 00:00 format requires special command which I have
 
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.