In the module code,i want to write a code with using IF functions.
for that i need to check Sheet cell values.
when i write within a function like this
Sheet.cells([33],[C])  to refer the cell value

Hello from Steved
I've got a cell with  5:00 I've converted it to 0510 when highlighting the
cell it shows 05:10:00.
Cell B5 has 4701, Cell C5 has 5:10

I am trying to enter a fromula using the conditional formating menu -
I wish to highlight the contents of cell A2 if and only if both the
following conditions are true
cell A4 = blank

I have a table that contains values I wish to extract. These values depend
upon matching the return search criteria in column A and another search in
row 1. I wish to return the value in the intersecting cell.
Example:

copuld someone please help me with my problem

I am at a impasse with trying to use the Rank function in Excel.
Basically, I'm lost. I'm trying to have excel rank a column of numbers
The rank goes below each number--such as: (The rankings are supposed t
be centered below the number)

I need to create an IF function that compares column "C" of two
workbooks and if they are the same(contains the same information) then
copy the contents of cell "I" to the first workbook in cell "G". Can
anybody help me?

I'm trying to do a spreadsheet function where I need to assign numerical
values to a letter.  Like calculating your collge GPA.  A = 4, B=3, C=2, D=1,
F=0.  Can I do that?

I have a excel  file from  a user that needs to  have only  two  of the
columns fit the sorting criteria.  The problem is how do  you  sort this file
when  blanks are in  the file and need to  be there afte rthe sort completes.
Icant have the sort take the blanks out.

I have a call center software that lets you create your own custom variables,
and if activate on a phone call all the variables are stored to one location:
CustomData.  Here lies in the problem.  I am trying to create a custom
report, but I get results like this:

Hope someone here can help me with an irritating problem.
I regularly receive an excel spreadsheet (Excel 98) which is derived
from an old DOS database.
When I try to work on this database (in Excel 2003) using normally

My daughter has spread sheet with two columns, C and F.  She wants to
compute the number of rows in which the test criteria is satisfied in
both columns C and F.  The following formula returns a “1” if the test
criteria is met in both, and a zero if one or the other criteria is ...

How do I make a pick from list but when a certain thing is already
picked then you cant pick it again below is an example
Candy                   /       Ice Cream                    /        
Prfference         /           Ranking

I find it very difficult to discern which column has the auto-filter "on" as
the is shaded blue and the others arrows are shaded black. I have to view my
spreadsheet at 70-75% all the time since it is so big. It would be wonderful
if that "on" arrow were red - it would show up ...

Another question now: I want to count the number of cells in the column I
mention below that are below the 95th percentile only if on another column in
that same row the value there is below its 95th percentile.
Basically I have two columns containing stock returns. I want to ...