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.
Posts by arlener
-
-
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.
-
I have an excel formula like this =(b1Scores!BD3)
but I want the digit 3 to be taken from a cell "B3" (that my VBA will write)
I think I need to use the INDIRECT but I can't get the syntax correct. This is what I have
=(b1Scores!BD&INDIRECT("B3"))
It shows this error #NAME?