Posts by arlener

Actually, because you ask this question, I tried one and it works. I thought I would have to tell Excel where to find the subs. Hard to believe it is so easy!!! Of course I have to pass extra parameters, but that's ok. Thanks anyway.

I want 2 modules to share macros. They can all be in the same workbook. When I update code to the macros I only want to do it once, even though both modules use those macros.

Excel 2007, Windows 10

Actually, you are right. I have my number in B2 and not B3 so when I changed that it works!!!

Thank-you so much for your help.

I don't quite understand how Index knows to look at this sheet but maybe I will figure that out eventually.

Thanks for trying, Rory but this does not work and the error is #VALUE!.

B3 is a cell on this sheet and all the rest is from a different sheet that I am trying to copy to this sheet.

B3 specifies what row to get data from other sheet. And I want my VBA to write to that B3 cell each time row changes.