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

@SkipVought, I have a tables divide into n sections in excel. At the top of the table there is an identifier tell which section the column belongs too. The numbers of columns in each section and the number of sections will defer depending on the table. I am need to do different tasks on each...

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

Gavona, I think the example i gave before is a bit confusing. But I think you are starting to get the idea. to clarify: I am trying to create a macro that produces all possible tables, given: - the table dimensions - dimensions are used defined. - the cell values can range from 0 to 10...

Seem to finding this hard to explain. Let me try this again. I am trying to create a macro that produces all possible tables, given: - the table dimensions - dimensions are used defined. - the cell values can range from 0 to 10, independent of location So for a table for a 2 x3 dimension...

This involves some combinations. Maybe I will try explain this in a different. Let imagine that each cell is a person holding a certain number of objects, say oranges. that person can hold between 0 and 10 oranges. the table is a collect of these people, classified in someway. eg nationality...

No, this isn't a homework question. It's part of a larger model that i am trying to build for work. any help would be appreciated

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

Thank you all for the feedback... Still working my way through it. A few new things to read up on, new to modelling. @SkipVought. Still trying to work out what approach, not started on the code yet. @Jges. There isn't a limit to how much an agent can handle. @MajP could you please send me...

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