Search results for query: *

Here is the code, all other code has been commented out. the problem lies somewhere in the following lines Option Base 1 Sub Profitability() Dim mostup() ReDim mostup(1 To Workbooks("Most Up.xls").Worksheets(1).UsedRange.Rows.Count, _ 1 To Workbooks("Most...

Here is the trouble line Workbooks("Most Up.xls").Worksheets(1).Range(Cells(1, 1), Cells(UBound(mostup, 1), UBound(mostup, 2))).Value = mostup Similar lines have worked in other programs When this line is executed: mostup is a 2 dimensional array (1 to 64350, 1 to 31) The array is being...

In a program I am writing I cycle through some arrays in order to get rid of a few unwanted values. the loop goes through the array and finds the value it doesn't like and then shifts each element after that up one. When the loop completes, I am left with a bunch of elements (not empty) that I...

A program that I am writing requires that i put two different columns into a two dimensional array. the code line that gives the problem is: daydata = Application.Union(Range("a1:a" & dayrows), Range(datatype$ & "1:" & datatype$ & dayrows)) The array has been previously ReDimed as...

I am writing a section of code that would go through an array and set repeat values to "" (null). I am using a For-Next loop to look at each element in the array. on the first iteration of the loop i get the runtime error 9, subscript out of range. It is clear to me that the variable i am using...

I am relatively new to VBA and have run into a problem i can not solve through tinkering of the code or searching of the web. Run-time error '1004': Application-defined or object-defined error To summarize. I am trying to copy a column of undefined length starting at cell A1 from one...