myarrayi

Hi all, I'm sure I'm missing something small, but does anyone know why I have to use "LastRow-2" in the code below to keep from ending up with 2 empty rows of data at the bottom of my ComboBox list? I guess I would get it if I had to use LastRow-1 since the array might be putting in an extra...

Hi, When I am passing a range to the below UDF, say A1=CorrelationCoefficient(B1:C100, 1, 2, 0) I am getting an VALUE error. Any reason why? The code is: Public Function CorrelationCoefficient(MyArray() As Double, Optional asX As Long = -1, _ Optional...

Normally I would use On Error but I want to find out why this doesn't work: In column A, put some values in cell A1 to A6, ensuring at least one value is zero. Dim MyArray() As Variant MyArray() = Cells(1, 1).CurrentRegion.Value Dim i, j For i = 1 to 6 j =...

I was wondering if anyone could help out here. Data is 20 columns (50k rows) with numbers and text (basically stock tickers with market values) and I am trying to use an array to speed up a loop. I already coded the For Next loop but was wondering if an array could improve the time to go...

On my worksheet, in column A, I have 5 rows of data and a heading in cell A1. Say: Name a a b c d This is my code without using classes: Option Explicit Sub NoClass() Dim MyArray(1 To 6, 1 To 1) As Variant Dim i As Integer For i = 2 To 5 If MyArray(i, 1) <> MyArray(i + 1, 1)...