Trying to write a TRANSPOSE formula to a cell:
wsMyWorkSheets.Range(Cells(3 + vHeaderSize, 9), Cells(3 + vHeaderSize, 8 + vHeaderSize)).Value = "=TRANSPOSE(VaR)"
In excel however, I get '=@TRANSPOSE(@VaR)' which in turn returns a #VALUE error
Asked
Active
Viewed 35 times
0
user9423162
- 27
- 1
- 6
-
21. use `.Formula2` instead of `.Value` 2. what is `VaR`? is it a vba variable, a named range? – Scott Craner Apr 19 '21 at 15:14
-
3. the `Cells(...)` should also have the parent sheet assigned to them `wsMyWorkSheets.Cells(...)` or you will get an error when the active sheet is not `wsMyWorkSheets.` – Scott Craner Apr 19 '21 at 15:17
-
VaR is just a range – user9423162 Apr 19 '21 at 15:20
-
A named range or a range variable in vba? – Scott Craner Apr 19 '21 at 15:21
-
you may want to include more of your code and explain what you are trying to do. – Scott Craner Apr 19 '21 at 15:24
-
The answer is indeed the .Formula**2** (.Formula still gives the @). Also, to make it work I needed to write the formula to just the very 1st cell, as one does manually.... – user9423162 Apr 19 '21 at 15:36