[RESOLVED] [Excel] VB Array Copying
Hey all --
I've generated the following code. However, when I run the Sub, which generates an extensive Excel document, the formulas and numbers come out as raw text. I can't figure out what's wrong, as when I reenter the same exact text manually, it works. ExArr is an array which is placed in corresponding Excel cells, ex. 27, 13 is M27.
Resolved! Thank you ThreadHelp!
Re: [Excel] VB Array Copying
Excel evaluates those assignments as string. So, for example, in M27, Excel evaluates "=(M6*10)/(4*M23)" as:
'=(M6*10)/(4*M23)
Try pasting that manually into an Excel Cell to see what I mean.
To fix this, you may do the following:
Code:
Cells(26, 13) = Evaluate("=(M6*10)/(4*M23)")
