Search results for query: *

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...

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...

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

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...

i will do my best to explain this lets say i have the following table as an example we can say it represents gdp over time 1 2 3 3 5 7 8 9 4 1 4 6 lets name this range("SampleRange") lets say there are 3 years being evaluated (each with its own similar table) per 3 different...

All, I am wondering whether it is possible to perform the following is there ONE line of code taht can create something along these lines array1(1,2,3,4) array2(1,2,3,4) is there one line of code that can create a 3rd array that contains the products of the components of the 1st two arrays...

all, i am trying to rename a chart/graph...when created, it is being assigned the default name, "Chart 29"...for some reason it is not allowing me to manipulate this value manually or via code...i tried the line activechart.name = "XYZ" and this is returning an error msg..does anyone have an...

lets say i have 5 combo boxes testcombo_1 thru testcombo_5 how would i get the following code to execute properly? for i = 1 to 5 combotext = "testcombo_" & i testvariable = sheetS(activesheet).combotext.value next i for some reason this creates an error and i cannot recall how to fix it...

what is the quickest way to assign a range of cells to an array? ie... TestArray = range("TestRange").cells this code does not work, but i am wondering if the above code can be slightly manipulated to place all of the values in the range into the array

assume that i have two spreadsheets open, A and B. I have the full file path name defined for both file a and file B my operations begin in file A, but at a point in the code, i would like to activate file b. how, using the filename to toggle between the two sheets, can i do this? thanks very much

I have named a set of 5 control boxes "Data_TransferTo1"...."DataTransferTo5" If i put the following code in, i can access the value of each drop down CurrentValue1 = Data_TransferTo1.value ...... CurrentValue5 = Data_TransferTo5.value if i try this other method... for x = 1 to 5...

Private Sub StandardReportComponents_Click() TempArray = Array("", "Portfolio", "Query1", "Query2", "Query3", "Query4", "Query5") TempArray2 = Array("", "Toggle", "SortDropDown_Portfolio", "ColumnSpecs", "Toggle_Trade", "TradeDisplay", "Toggle_SubBanks", "Toggle_FASB", "Toggle_SecClass"...

is there a way to locate the last column/row on a worksheet that contains actual text? end will not work here because that simply locates the bottom-most and right-most points containing any change to a cell, whether that be something exectued previously or currently is there a simple line or...

when i execute application.ScreenUpdating = false my graph attributes are formattable but for some reason axis font size will not budge! when i remove the line of code that disables screen updating everything runs as desired (font attributes can be manipulated) whats up with that yo!!! any...

is there a quick way to reset the value of all variables in a project to null(empty)?

does anyone know the equivalent syntax for looping through the elements contained within an array? for example: for each cellvalue in range blah blah blah next cellvalue how would this same form be applied to the array? thanks

trying to assign names of various boxes to an array ie testarray = Array("Check1","Check2","Check3") then based on value of a different control box change the values of these in the array to conform ie if checkall.value = true then for i = 1 to 3 testarray(i).value = true next i else...

i have the following code which grabs number from a text string, and converts them to the typical excel date format PrimaryGraphArray(UserGraphLoop, 10) = Application.WorksheetFunction.Text(Month(Left(PrimaryGraphArray(UserGraphLoop, 10), 8)) & "-" & _ Day(Left(PrimaryGraphArray(UserGraphLoop...