worksheets("House").Range("B9").Copy Activesheet.Range("F2")

--
Regards,
Tom Ogilvy


"ladyhawke" wrote:

Got index to work with named cells. Just out of curiosity: how do I
reference a cell in a sheet, so I can copy values from other sheets?

regards,
ladyhawke

ladyhawke skrev:

How would Index or vlookup be used on the other sheets and are there
nop option to avoid storing the data once more (linked cell)?