Rather than use 65536, use a method to determine the last used row, such as

LastRow = Cells(Rows.Count, "A").End(xlUp).Row

and use that to determine the size of the data to be processed.

--
__________________________________
HTH

Bob

"jan" wrote in message
...
hi,

i have linked 1 worksheet to 2 other worksheets (all 3 in the same file)
using VLOOKUP

this in total pulls over 3 different cells into 3 different columns for
all
65536 rows.
a update will take 30 minutes. i assume thsi could be more efficient,
however i don't know how to do that. any suggestions?

thanks.