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 line
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
--
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"
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 corr
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
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 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
invoice
