Gerrit Grundling
>To: excel-macros@googlegroups.com
>Sent: Wednesday, March 5, 2014 12:59 PM
>Subject: $$Excel-Macros$$ Re: Array from range
>
>
>
>Thank, Paul, that did the trick
>
>
>"TIP" is the number of rows in the first column I'm considering, and
Thank, Paul, that did the trick
"TIP" is the number of rows in the first column I'm considering, and was
created in an attempt to automate the program for future use.
Then, in order to check the algorithms, I went and set "BETADEG" as a fixed
range, until I could make it dynamic as well ("TIP"
ou can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
>
> From: Gerrit Grundling
>To: excel-macros@googlegroups.com
>Sent: Wednesday, March 5, 2014 8:16 AM
&g
Thanks for the reply, but that didn't solve the problem.
Neither does this:
BETADEG = Range("H19:H28").Value
For s = LBound(BETADEG) To UBound(BETADEG)
BETA(s, 1) = (Pi / 180) * BETADEG(s, 1)
Next s
On Monday, 3 March 2014 21:17:12 UTC+2, Rajan Verma wrote:
> you should give column dimensi
you should give column dimension in this below line
BETADEG(s)
it should be like BETADEG(s,1)
On Friday, 28 February 2014 07:23:35 UTC-7, Gerrit Grundling wrote:
>
> Greetings, all
>
> What am I doing wrong here? I am trying to create an array from a range,
> but keep getting the "Run-time e
