Search results for query: *

Hello all, am getting the above runtime error when the macro gets to this line: Worksheets("sheet3").Range(Cells(7, a), Cells(b, a)).Select = WorksheetFunction.Transpose(y) any ideas, please help Sub Optimal_Structure() 'This model finds the optimal structure for an agent structure...

Dear experts I am trying to wirte a could that uses labels in columns to define the start and the end of a range. So far I have the following code. Running into some trouble when I try to define the range , v in the code below. v is meant to be the range define using the start and end indexes...

Dear experts. I am trying to create a number generator over a range of cells and being new to vba the only way I can think of doing it is using loops and refering to each cell. Hopefully you can help. Here is the detail: Create a table in excel of dimensions x and y, with x and y being...

Dear all. I am trying to write code that finds the max value in an array and returns te value and index reference of the value. I have come up with the following code so far but I am not getting a "subscript out of range" error. have no idea where I have gone wrong. any ideas. Option...

I am trying to develop a model that calculates the commission under various scenarios(assumptions). I have developed something that using loops (quite a few loops) to generate all the sceanrios. However I am finding this to be quite slow at the moment and the time taken may be restrictive to...

Hi All. I have been asked to develop code that works out all the possible structures a brokerage firm can take to maximise the charges it takes. If we assume that there are N management levels and under each level there are k types of brokers. For each type of broker the commission charges are...