Search results for query: *

Could it have something to do with my version of excel (2002)?

Yeah it works fine. I believe my code is not picking up all my constraints. Interactively it can definitely pick up my constraints.

I am having trouble writing code to use solver to get the correct asset allocation percentages. The problem I am having occurs when I enter my constraints. It seems that excel is only picking up 2 of my three constraints. Specifically, it is not picking up my constraint that says that the total...

I am having trouble writing code to use solver to get the correct asset allocation percentages. The problem I am having occurs when I enter my constraints. It seems that excel is only picking up 2 of my three constraints. Specifically, it is not picking up my constraint that says that the total...

yes Static cc used to have to do with columns. Both rows and columns were highlighted using the original code that I got, so I stripped all column-related code out. (save for that line) That code works great, thanks for the help.

I have a spreadsheet where I can click on any cell and the entire row will get highlighted in the color of my choice. For example, if I click on G10, all of row 10 will highlight in a light blue color. Now I want to be able to click anywhere in row 10 again and have the row go back to the...

I have a spreadsheet where I can click on any cell and the entire row will get highlighted in the color of my choice. For example, if I click on G10, all of row 10 will highlight in a light blue color. Now I want to be able to click anywhere in row 10 again and have the row go back to the...

If that is the case, then I only need to use the countA part of the formula to name the range, the offset function that I am using to define the starting point of my range becomes moot, correct?

I am trying to create a dynamic named range (actually a series of them) and have a summary table above them for easy viewing. For example my data starts in row 13 and my summary table goes from rows 4:10. My data goes from O13:O35 and is named "Variable1" my named range is defined as...

I am trying to take write VB code to help me facilitate a copy and paste. I want to copy information from EITHER Sheet 1: Column G or Column H to Sheet 2: Column B. I can copy it based on a double-click fine, but I want Sheet 2: Column B to know (when it gets copied) where it came from - either...