$$Excel-Macros$$ 2d array: ignore blank cells

Greetings, all I have several data sets for selected aerofoils, which I have now transformed to a 2d array of CL(AoA, Reyn) for each aerofoil. I want to perform 2d interpolation using XonGrid Interp2d.

Re: $$Excel-Macros$$ Two-dimensional array with numbers and "#N/A" - turn "#N/A" to blank cells

Thanks, that did it. On Thursday, 26 June 2014 23:09:05 UTC+2, Steve Weaver wrote: > > I believe you can accomplish by enclosing your formula as follows: > Iferror((your formula),""). > > Steve > > > Sent from my iPhone > > On Jun 26, 2014, at 4:34 PM,

$$Excel-Macros$$ Two-dimensional array with numbers and "#N/A" - turn "#N/A" to blank cells

Greetings, all I have aerofoil data for a selection of Reynolds numbers and a selection of angles of attack. I have now divided these into two-dimensional arrays to plot z=cl(AoA, Re) and z=cd(AoA, Re). I have used VLOOKUP to generate the new 2D arrays, but I now have a mixture of numbers and

$$Excel-Macros$$ Creating a popup "window" displaying messages from main program

Greetings I have created a code which takes a long time to run. The code has certain messages to be displayed in the window e.g. "CIRCULATION LOOP NUMBER _", "ANGLE OF ATTACK LOOP NUMBER _" etc. It must popup when the command button is pressed, and display the messages when prompted by the mai

$$Excel-Macros$$ Re: Converting Fortran to VBA: Different results from the same code in two languages?

On Saturday, 15 March 2014 10:54:42 UTC+2, Gerrit Grundling wrote: > > Greetings > > I have coded , line-for-line, a Fortran code into VBA. Unfortunately the > Excel program gives me different (and, I daresay, nonsensical) results to > the Fortran original > > The

$$Excel-Macros$$ Re: Converting Fortran to VBA: Different results from the same code in two languages?

HELPFUL HINT: I paid a severe performance penalty by using "WorksheetFunction.Pi". So I created a variable PI instead. There are many ways to calculate π, but I just use this simple relation π ≈ 355/113 On Saturday, 15 March 2014 10:54:42 UTC+2, Gerrit Grundling wrote: > Greeting

Re: $$Excel-Macros$$ Re: "Two-dimensional" interpolation

*“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you 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-...@googlegro

$$Excel-Macros$$ Re: "Two-dimensional" interpolation

jan Verma wrote: > Hi > > make your array as "double" data type not "Long" > > Thanks > Rajan. > > > > > n Wednesday, 26 February 2014 07:07:45 UTC-7, Gerrit Grundling wrote: > > Greetings, all >> >> I have attached som

$$Excel-Macros$$ Re: Array from range

it dynamic as well ("TIP" number of rows but in another column). I guess that's a problem for another day. On Friday, 28 February 2014 16:23:35 UTC+2, Gerrit Grundling wrote: > Greetings, all > > What am I doing wrong here? I am trying to create an array from a

$$Excel-Macros$$ Re: Array from range

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

$$Excel-Macros$$ Array from range

Greetings, all What am I doing wrong here? I am trying to create an array from a range, but keep getting the "Run-time error '9': Subscript out of range" warning. TIP = Application.WorksheetFunction.CountA(ActiveSheet.Range("D19:D1048576" )) 'Counts the number of active rows below the first as

Re: $$Excel-Macros$$ Re: "Two-dimensional" interpolation

On Thursday, 27 February 2014 16:33:41 UTC+2, Paul Schreiner wrote: > > What does your function LinInterpolate() look like? > > Evidendly, you have a function called: > LinInterpolate > > and it looks like it must accept (3) arguements, so it may look like: > > Function LinIterpolate( Var1,

$$Excel-Macros$$ Re: "Two-dimensional" interpolation

> > Please help: What is wrong with the following? > ReDim ClArray(5) As Long ReDim ReArray(5) As Long ClArray(1) = LinInterpolate(ALPHEFD(J9), Sheets("AIRFOIL_DATA").Range( "B3:B44"), Sheets("AIRFOIL_DATA").Range("C3:C44")) ClArray(2) = LinInterpolate(ALPHEFD(J9), Sheets("AIRFOIL_DATA").Rang

$$Excel-Macros$$ "Two-dimensional" interpolation

Greetings, all I have attached some aerofoil data for a Clark Y foil. This data is also available in my spread sheet. The Reynolds number is given in the heading as 5.00E+04, 1.00E+05, 5.00E+05, 1.00E+06 and 3.00E+06. I need to find Cl and Cd at an AoA for a Reynolds number: GetCl(AoA, Re)

Re: $$Excel-Macros$$ VBA for-loop: for I = (current cell) to (count active cells below)

property" of the textrange object. > that's why I used nRows instead. > > > Hope this helps. > > > > *Paul* > ----- > > > > > > > > *“Do all the good you can,By all the means you can,In all t

$$Excel-Macros$$ VBA for-loop: for I = (current cell) to (count active cells below)

Greetings, all In MatLab I can control a for-loop by specifying the length of a vector as the number of times, e.g. for I = 1:length(vector) for J = 2:(length(vector)-1) . . . end end Now I am in Excel, and I want the for-loop to be run as many times as the length of a column of entr

$$Excel-Macros$$ Re: Introduce Yourself !!

> > Greetings, all > My name is Gerrit Grundling, and I am an aeronautical engineer. Although I have learned programming in TurboPascal (many moons back, when the animals still talked, the trees still walked and fish could fly) and C (ten years ago), the bulk of my programming has ha