Home

repeating a macro

%3CLINGO-SUB%20id%3D%22lingo-sub-911165%22%20slang%3D%22en-US%22%3Erepeating%20a%20macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911165%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%2050%20columns.%26nbsp%3B%20Each%20column%20performs%20an%20identical%20calculation%20using%20Solver.%26nbsp%3B%20Each%20column%20is%20independent%20of%20any%20other%20column%20(all%20data%20needed%20by%20perform%20the%20calculation%20and%20optimization%20using%20Solver%20is%20contained%20within%20the%20column).%26nbsp%3B%20I%20have%20created%20a%20macro%20that%20performs%20the%20Solver%20calculation%20on%20one%20column.%26nbsp%3B%20I%20want%20to%20be%20able%20to%20repeat%20this%20calculation%20on%20other%20columns.%26nbsp%3B%20Ideally%2C%20I%20would%20like%20to%20have%202%20cells%20in%20my%20spreadsheet%20that%20tell%20the%20macro%20to%20start%20the%20calculation%20on%20column%20M%20and%20end%20the%20calculation%20on%20column%20Z.%26nbsp%3B%20Of%20course%2C%20I%20want%20to%20be%20able%20to%20change%20the%20entries%20of%20those%20two%20cells%20to%20start%20and%20end%20with%20any%20two%20columns%20I%20choose.%26nbsp%3B%20I%20am%20not%20proficient%20in%20VBA%20programming.%26nbsp%3B%20Existing%20macro%20to%20perform%20the%20calc%20in%20one%20column%20was%20done%20by%20recording%20the%20macro.%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-911165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
chickolini
Occasional Visitor

I have a spreadsheet with 50 columns.  Each column performs an identical calculation using Solver.  Each column is independent of any other column (all data needed by perform the calculation and optimization using Solver is contained within the column).  I have created a macro that performs the Solver calculation on one column.  I want to be able to repeat this calculation on other columns.  Ideally, I would like to have 2 cells in my spreadsheet that tell the macro to start the calculation on column M and end the calculation on column Z.  Of course, I want to be able to change the entries of those two cells to start and end with any two columns I choose.  I am not proficient in VBA programming.  Existing macro to perform the calc in one column was done by recording the macro.  Thanks.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies