I am new to this website and to Visual Basic, so I hope I can find some help here.
Basically, I have an already existing spread sheet that performs one set of calculations fine, based on 4 variables. SOmetimes I have to manually input 100+ sets of 4 variables and copy and paste each result the old fashion way (Ctrl C etc)
I am looking to be able to write VB such that I can type the sets of variables into cells in excel, and then the VB code takes each set individually and runs them through the excel calculations, and the VB code then to copy and paste the results.
I am trying to take the repetition out of the process.
Any help or ideas would be brilliant