Hi Owl,

If your formula contains and $ then try removeing them.

This should allow your code to work.

However, be very carefull when doing this as if you drag your function in the
wrong direction it will stop working all together. I would suggest just
removing all of the $'s from before the row number if dragging down or before
the column letter if dragging accross. ie$A4 or A$4 as this will keep the
other portion absolute.

HTH

Thanks,

Simon

owl37 wrote:
Hi,
I am using a vlookup to extract comments relating to particular ref. no's
from a seperate worksheet.
The vlookup has been created and works for one cell.
However, when I try to autofill it down it copies the formula OK but the
results don't change.
Whne I double click in each cell and press enter the formula seems to
refresh and starts to work.
There are over 600 instances so this will take some time!
Please help.
Thanks.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200610/1