Recent content by jluft

All, is there a way, WITHOUT vba, to create the following formula? Create a reference cell that contains a # that varies according to user preference. Target Range A1 = 5 A2 = 5 A3 = 5 A4 = 5 A5 = 5 A6 = 5 A7 = 5 A8 = 5 A9 = 5 A10 = 5 in column b i would like to create some sort of formula...

glenn, thanks...i am using a control button...i guess the two types would be control buttons (greater control over properties) and then forms which are the type taht ask whehter you want to assign a macro to them i am using a control box and it is returning the error that i had mentioned. what...

come out come out wherever you are

zameer, i am not sure how to do that. i thought i was doing it properly but i wasnt. i think i require some spelling out isnt abc = application.caller an attempt at what you just said?

i am using a group of control boxes to call a routine. depending on which control box calls the routine it will perform slightly different operations to identify the control command button that called the sub i am trying to use abc = application.caller but this is returning an error msg...

i am running a program within which millions of pieces of data are stored in arrays. i am not having an issue with speed of the program, but i am having a problem in that when too much data is entered into the areas (the file size is variable), i receive an Out of Memory message once it...

skip, that was my initial plan..but for some reason it was calling some of the variables undeclared...i will try again oddly, it is calling the variable ambiguous UNTIL i rename it..normally it would be hte other way around (ambiguity being caused by declaration in multiple locations) thanks

mike, it is declared in a standard code module (there are about 15-20 or so in the workbook) i do not get an error...the strange this is that even though i am declaring the variables as public (or global, as i tried them), it will tell me that the variable is ambiguous unless i declare it in...

i work at a securities firm. we have a vendor suppling us various attributes of securities that occur monthly over 30 years on thousands of securities across multiple scenarios approx 500 x 360 x 10 x 5 i am placing the data which is given to us in spreadsheet form into an array. this is very...

the reason i am trying to circumvent the use of loops is that i have millions of pieces of data that need to be aggregated and it takes a long time to do this within the confines of excel (ie without the aid of database) would writing a function here work any faster? im guessing that the answer...

i have a variable in a project that is defined in one module. then, another module is called. for some reason the variable is not passing through to the new module when called. i have defined the variable as global...why would this be hapenning? thanks

is there a way to take arrays of equal size and add them to one another (without looping)? ie. array1(1,1,1,1) array2(2,2,2,2) goal would be to set array3 to equal (3,3,3,3) thanks

i posted to the original as well...is this not a possible operation at all? you can sum an entire array but not a portion of it?

skip, thanks for the response. unfortunately i do not have this option as the data i am dealing with is much more robust than my example. did you happent o see my 2nd posting? i presenteda simpler example..do you know if anything along these lines is possible or is it something that simply...

Sub test() Dim testarray(1, 2) Dim fullarray(1) fullarray(1) = Range("TestRange") tester = Application.WorksheetFunction.Sum(fullarray(1)) tester2 = Application.WorksheetFunction.Sum(fullarray(1)(*, 2)) End Sub "Test Range" is the following range 1 2 2 4 3 6 4 8 5 10 6 12...