$$Excel-Macros$$ Re: Find, Copy, Paste to different worksheet

What you're looking for, I suppose, is called vertical lookup (vlookup). Select it from the excel formula bar to find out how it works. Then just use it in VBA with ActiveCell.FormulaR1C1 = "=vlookup(RC[-1],'individual worksheet', 14,FALSE)" --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Run function from different workbook

e the code is not in the txt, but in the dummy excel. WeekStart is a public function. How can I make this work, without needing to copy all data into the dummy file. Thanks, Maarten --~--~-~--~~~---~--~~ -