Hello,
I want to insert this formula in excel using Visual Basic but I keep getting error messages.
=INDIRECT(""&B17&"!F67")
Can anyone help me?
Thanks in advance
Hello,
I want to insert this formula in excel using Visual Basic but I keep getting error messages.
=INDIRECT(""&B17&"!F67")
Can anyone help me?
Thanks in advance
Re: trouble inserting formula via VBA
To expand on inag's response...
In VBA a quotation mark (") dictates the start/finish of a string. So the following will cause an error:
In VBA, if you want to use a quotation mark within a string you need to escape it by doubling it like so:
Re: trouble inserting formula via VBA
Basically what I have now is a list of all my sheets from B17 to B (17 + i) depending on howmany sheets I have.
What I'm trying to do now is get numbers from these sheets in this first sheet. In C17 D17 and E17 from the first sheet which is a resume of all other sheets. I want numbers from sheet 2 (F67 F75 & F77). Next to B18 (in C18 D18 & E18) from sheet 1 I want numbers from sheet 3 (F67 F75 & F77).
Don’t have an account yet? Register yourself now and be a part of our community!