I have a huge range of cells in which the data is entered manually. I need
to cross check whether the data has been entered in all the cells in that
particular range.
I had used the formula = COUNTBLANK(range) to get the number of blank cells

I'm trying to run a macro that looks like this :
--------------------------------------------------------------------
Sub LoopMacroTest()
Dim lCount As Long

Is there anyway in Excel to format a cell so if the user types 61/4 it will
convert to 6.25? If not what is the best way to create a conversion so the
user can type in 51/2 and have 5.5 show up, either in another cell or in the
same cell?

I want to highlight a cell through conditional formatting - it depends on the
results of multiple cells.  So, how could I put a formula in for conditional
formatting for the following:
inside the conditional cell there is a date 1/29/07

Is there a way to get a column of numbers from one sheet to another, where
rows have changed order.  I have compared sheets before to the same column,
but need the data.  examples have are:
=IF(OR(COUNTIF($AA$1:$AA$3000,AA99)=1,AA99={"","."),"",COUNTIF($AA$1:$AA$3000,AA99))

I have recently been renaming large groups of files.  I had not realized that
I had selected all the files when renaming.  Now I have: Name (1), Name (2),
etc.  Is there a way to recover the previous names of the files I did not
want to rename?

I have a spreadsheet that is 4 columns wide, I want to be able to tab to each
cell and when I reach the 4th cell in each row when I push tab I want it to
go to the next row
Is that possible?  I have tried hiding the remaining columns, deleting the

How do I map a key to a particular keystroke. I want to have a key that is
mapped to place a check mark in the current cell. I would like to do this
without creating a macro if possible

When I go to a cell which isn't part of a pivot table and use the "=" to
refer to a cell in the pivot table, it appears as ="GETPIVOTDATA etc etc etc".
This has only started happening recently (since i had Excel reinstalled).  
Before, it would refer to theactual cell (e.g."=C3").

I have applied 3 conditional formats to a cell and need to apply a 4th.  I
thought I could amalgamate one of the conditions to cover this 4th option but
I'm not sure what to do.  I am in cell A3 and the condition currently is
=if(or(D3=Housing Benefit NIHE",E3="Housing Benefit ...

I have a sheet with numerous ROUND functions.  I want them all removed.  How
can I do a search/replace to remove them all at once.
For example, I want to replace
=ROUND(A1*B1,1)

Is there a quick way to subtotal by groupings, ie everty 100 rows, insert a
subtotal?

I used to compare similar word or excell files with the Compare Tool. How can
I do that with Office 2007?

Hi, I have seven worksheets in my file, which come from online source
(our data server). Currently, the user has to manually do a 'Data
Refresh' everytime he opens the file, for each worksheet. How can I
make sure that everytime the XLS file is opened, the data from the web

Sorry for posting here, but I don't know where to ask this.  
I have no idea how people view newsgroups other than the way I do, using the
microsoft website with a regular browser.
Whenever I respond to a post, I always delete the previous response text, so