Thanks Basole!
Is there someone I can get to just get this work done for me? Need it by
Monday.
I wont mind paying then to burn my weekend, cos I am sure someone out there
can do a much faster job than me.
Just a database (all info required below in tabular forms) of customer
Thanks Ganesh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ganesh N
Sent: Wednesday, 5 March 2014 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Record Macro to Filter out blanks
Hi Elaine,
Replace with Criteria1:=
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 dimension
What value do you end up with for TIP ?
You're ReDimensioning BETA as size (TIP)
But BETADEG will always be (10) (H19:H28)
So, if TIP is more than 10, then it might cause a problem.
However, when I changed:
Cells(s,34)=BETADEG(s)
to:
Cells(s,34)=BETADEG(s,1)
your snippet of code ran
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
I understand.
Actually, I started writing that, thinking that it was going to be the problem.
Then, decided to do some testing and observation and determined that it was NOT
the cause, but might become a problem in the future, so left it in the email.
Paul
Slowly but surely I'm getting there. Thanks for the help so far.
I am including an Excel file with the airfoil data, function
LinInterpolate and functions Floor and Ceiling. None of these are my
own, as I found them on the interweb.
I have commented out my attempt at automating the linear