Folks:
I have a small spreadsheet consising of 5 columns & 10 rows of information.
Each day I manually update this spreadsheet so I end up with a new set of
data in the rows & columns.

What are all that and how to do separate $ n its number?

I am using Visual Basic 6 to automate Excel.
When the reference to Excel is early bound (bound to Excel at design
time), everything works fine, for example
e.Range(e.Cells(w, x), e.Cells(y,z)).HorizontalAlignment = xlCenter

Using Excel 2002:
This is probably one of the top ten most asked questions, and saw some
related posts.  But like to know, if there is a simple non-formula way of
clearing blank rows in a list?  Mark the cells, then just have a action to

I want to make a worksheet with buttons that when clicked produces a pre
made list. However I need to have this in cells next to each other, so I can
use them in a test results sheet I produce for my customers. I currently
type in the data manually and to be honest most of is repeat ...

I have a range of number between 1 and 5.  Four of the cells in the range
display formulas.  The formulas I am using to determine the number of 1's,
2's, 3's, etc  are: COUNTIF(A1:A233,"1");..... COUNTIF(A1:A233,"5").   How do
I get the COUNTIF formulas to count the cells ...

I have some columns in Excel which include numbers and blank cells. Is there
anyway (with the use of functions) to copy these numbers to the next columns
without blank cells and in continuing order ?
(For ex. Lets say i have the column A in which is: A1= 45,78  A2=53  

I made an attendance worksheet that has the first three columms tthat need
protection and the columns with formulas in that need protection but the rest
of the areas need to be available to add information.  how do I lock or
protect just what I want protected and allow the other ...

I have a date in a field 03/25/2006...I would like to change this date to
only show day and month of date 03/25 .  I think I can use the Day  and Month
functions to pull out the day and month from the date.  
Can someone help me with using one fuction to get day and month from ...

I really need help to delete a password on a workbook I made 3 or s
years ago in office 2003. Now I have office 2007 and need to edit th
document but cannot for the life of me remember the password. I kno
there is a way to delete it without knowing what it was. I have hear

There is a weird problem that I have to deal with. A particular user
of a shared workbook (between 8 people or so) is  having difficulty
opening it using Excel 2003. It seems to render properly, and then
crashes, with the window that asks whether to send the crash report to

Hello, Excel group.
I've run out of keyword ideas to look up the answer myself, so here I
come with a question.
I have to copy data out of a whole bunch rows in a worksheet and paste

I am working on learning Pivot Tables and wanted some advice.  I would like
to use the Pivot Tables to work with state testing data.  Fields that I
would be working with would include:
Student Name

How to do the following conditional:
if h2 > 30 and h2 < 60

Hello to everybody,
I have a sheet for showing a certificate of marks. Sometimes Ithe sum of the
marks need to be shown when printing the certificate, and sometime I n don't
need to see the sum.