Hi,
I need to paste data into an excel sheet from access, and then sort b
date field. However when the date field is entered by paste functio
into an excel cell the formula from access is retained which prevent
searching on the date.
To solve this manually, I need to edit the cell (by F2 seems th
easiest) and then enter. This changes the formula into a searchabl
date.

My options are to either work out how to do the manual process above o
work out how to remove the formuala (I have tried copy and paste specia
as 'values' which didn't work)
If you can offer advice on how to create a loop via a macro to edi
each cell in a column and then 'enter/return' this would do it. I ca
create the macro, but what I don't know is how to code the loop t
select the next cell.....

Ton

--
Tony777

-----------------------------------------------------------------------
Tony7777's Profile: http://www.excelforum.com/member.php...fo&userid=1525
View this thread: http://www.excelforum.com/showthread.php?threadid=26883