12pt;

Hi I have code that I would like to make a small change to but need some help with. I only need the first cell in all the ranges in all the “arr1” in my code below to be increased by one row , so the 1st change is the current range is Range("D22:I36") change to Range("E22:I36"). I can do...

Hi This is my first post. I’m trying to set up a macro that uses Solver and I have some code below. I was wondering if someone could take a look to see if I’m on the right track. This is what the macro should be doing: Numbers will always be present in one or all of the...

Using VBA (must be used because there is more to this coding) I need to find the location of a manually entered number, 1 to 10 are the only choices. The number gets entered in cell C17. As an example say I’m looking for number 7 (could be any number 1- 10). I have 5 columns where the above...