I step through (F8) a great number of macros.  As i do
can I quickly (in the immediate window) inquire into the
data type of a given variable?
in the Sub I have i = 3

I am trying to calculate the time between 8:00 am and 4:30 pm.  It is giving
me 8 hours only and not the 8.5 hrs.  Is there a way I can do this?

All I need is the product of two cells in a third cell.  I entered an
equation =B29*D29 in the third cell but the product is wrong.  Checked it
with calculator and another application.  One of the two cells being
multiplied is formatted for currency, but other instances of the ...

I downloaded a workbook that had hidden columns so I copied the worksheet to
a blank worksheet because I didn't know the password that protects it.  Then
a multi-row triangle appeared across two columns.  
What does this triangle mean?  Why does it move?  Why does it disappear?

Not specific to Excel but I hope somone here has the answer.  I know I can
passoword protect a file, but is there any way to password protect a folder
rather than each file in that folder.
Thank you!

From a database one of the dataset contains a vehicle type for example
pushbike, small van etc. however if the booking is made online it precede the
vehicle type with an * meaning if I countif, sumif pushbike it counts both
types of records.

I need to put two formulars together in a cell in my excel's worksheet.  For
example, =IF(A1=0, B1*2,1) and =IF(A1:F1=0,0,1).  I need to put these two
formulars together in a cell.  What is the exact way I should put them?  I
have tried =IF(A1=0,B1*2,IF(A1:F1=0,0,1)).  However, ...

how do i make a macro to open up the form...for an excel spreadsheet with
data being entered?  I tried making a new macro..then hitting the form
button...
and the macro said activeworksheet.open....I forgot.  anyways it came back

I am trying to select multiple items from the drop down list in the page
field of my Pivot Table.
Instead of just the "show all" option - I'd like to be able to display the
checkboxes for selecting individual items in the drop down list.  

I need to put two formulars together in a cell in my excel's worksheet.  For
example, =IF(A1=0, B1*2,1) and =IF(A1:F1=0,0,1).  I need to put these two
formulars together in a cell.  What is the exact way I should put them?  I
have tried =IF(A1=0,B1*2,1,IF(A1:F1=0,0,1)).  However, ...

TABLE:
                IGNORE    OK    REVERSE
BLANK                Cost1    Cost2    Cost3
    CC    ID    TEXT    Cost1    Cost2    Cost3

did 2007 excel address some of the validation requirement  as below
1) Apart from validating list of the values, can it throw different
pre-defined messages for defined input values and different error alerts for
different type of invalid inputs

I need to ROUNDUP an Excel column that contains 250 numbers.  Is there a way
to do this without rounding up each cell individually?

I have a spreadsheet with 1100 rows and 60 columns.  I had set a freeze pane
at row 6 and column 5 intersection.
This allowed me to scroll down and keeping the first 5 rows visible at all
times.

Is there any function or macro to get all the available built-in functions
from the Microsoft Excel?
Please help me.
Thank you,