array vba

Dear All master, if i use the code below after select range in column a then the results appear in column b and i want after column b the desired results appear in column c. Please solve thanks roykana Sub GetFileNamebykana() Dim title As String Dim Rng As Range Dim selection As Range Dim...

Dear all Master, vba code runs slow for 100000 row records even though I'm using vba code with dictionaries and arrays. Please solve. and also why the code run time result is different and I attached a screenshot of the time result. thanks roykana Sub Demo03() Dim Rng As Range, Ds As Range...

Hey guys, I'm trying to get the average of an array(no empty values) i have. I'm trying to do something like: averageMonth = Application.WorksheetFunction.Average(AryNoBlanks) And i get the error: 1004 unable to get the average property of the worksheetfunction class Am i just miss-using...