Thanks Bob, but i'm a bit of a thicky when it comes to this, can you explain
a bit more simply how i would do this....

Thanks again

"Bob Phillips" wrote:

For Each cell In selection
'do your stuff
Next cell

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"148steve" wrote in message
...
I want to create a macro that will carry out actions on cells below each
other or side by side automatically. I think it is called creating a loop
macro but not to sure.
At present i have a spread sheet which i input data (copy and paste) from
another application. The data is numeric, but when i paste it into excel
is
thinks its a text entry. I have done all the normal stuff but i have to
place
the cursor at the end of the data in the cell, press F2 and then
backspace.
This is the action i would like to run the macro on as i have to do this
in
every cell.

I have create a macro to do this action but it will not allow me to
highlight an area and run it for every cell.

Can anyone help please???