In a marco,  
If I write  --->   EN = cells(1,1)
then, EN will equal to the data of cells(1,1)
The problem is :

I have written a macro that the cursor will stop at uncertain cell everytime
finally.
I would like to show the x and y of the cell at range("A1")
e.g the cursor stops at C3,  then range("A1") shows ---->     3,3

I have several hudred columns of text cells interspersed with blank cells.  
Instead of manually deleting each blank cell, I would like to do this with a
formula, or a macro, although I am not good with macros.
I would appreciate any help I can get.

Thank you Roger.  However, I am using Excel 2007 and it has NO "Find" in the
toolbar.  Is it hidden?  It won't show up in "more", either.

If I unprotect and then protect one of the sheets in a workbook, it will
freeze up when I hit the tab key at the last unlocked cell in the row. I
would like to know how I could have a warning message appear whenever I open
the workbook.

I write a macro to find a pair of data at different cells in a worksheet.
After finding, I would like to get the x of the cells or Y of the
cells..........
for example, the found data at cells(2,2) and cells(3,4)

I have written a macro that the cursor will stop at uncertain cell everytime
finally.
when the cursor stop, I would like to show the x and y of the cell at
range("A1")

I'm using the grouping function in Excel to collapse several sets of adjacent
"detail" columns.  I would like to place a label next to the "+" sign to
indicate what kind of details will show up if the column is expanded.  Could
some one advise how I might do this.  I tried the ...

I have cells formatted as fraction, up two digits. We are a mfg. company
cutting metal and if it is not on a tape measure, we don't use it. If we
input in an odd decimal value, we can get stuff like 17/20 or other wierd
unusable fractions. Is there a way to have the same cell of ...

In a selected range of a partial or whole worksheet, is there a way to clear
the content of the cells which are selected but are NOT protected (or not
marked as "locked" in an unprotected sheet) while keeping all formats and
locked/protected cells in that range untouched. -- Is ...

I just cannot solve this one. Any help you can give is much appreciated......
There are 12 sheets labled Jan, Feb Mar etc. Each sheet has the following
Col A - Name
Col C - Data to be summed

I'm sure this is a very basic question, but I can't seem to find the answer
in Excel Help. How to I reference an option button in an if then formula?
Any help would be appreciated.
Mike

How do I copy / duplicate a worksheet within a workbook without having to
reconfirm all the cell names each time I copy the sheet over?
My worksheet has some 27 cell names & I may copy the sheet over many times
within the workbook - thus spending a lot of time pressing "Enter" to ...

I have a spreadsheet of work orders with start dates in column G and finish
dates in column H.  I would like to be able to pull all records between
certain start and finish dates - this would change each month (ie all records
between April 1 (start) and April 30 (finish)  and ...

I was wondering if it was possible to read a text input file and compare
that list to see if it exists in excel.  If it does, can we highlight the
entire row.  This way, I can delete the un-lighted rows.  The row that we
want to compare or match is in Column A.