Recent content by misterminis

Thanks a bunch CautionMP I more or less looked at your code and came up with the following.... Option Explicit Option Base 1 Dim i As Integer, j As Integer, column1 As Double, column2 As Single, column3 As Single, column4 As Single, rowtotals As Double Dim total As Single Dim matrix(4, 4) Sub...

Hey all, I am trying to rite a sub that makes a simple 4 X 4 array that is full of values I/anyone have input and then puts those values on the spreadsheet. I first tried doing a dynamic array and that did not work. I read some tips elsewhere that would suggest a fixed array instead, but I have...

Thanks everyone. I actually got it to work by dimming p, v, and a instead of density, velocity and area. I did figure that out through break mode, so thanks SkipVought and everyone else.

I'm creating a user form to calculate the lift force of a helicopter and the user form always returns a value of 0. Here is my code. Private Sub calculatelift_Click() Dim density As Double, velocity As Double, area As Double, lift As Double 'Choosing units for the air density If kgperm3 Then...