Can Sub Routines Be Performed
Aug 22, 2008
Many years ago I wrote some structural analysis programmes in BBC Basic. I still use them but the hardware is now getting old and I am worried that, if it packs up, so do my calculations. The calcs. in BBC Basic include many subroutines which, basically, run the same calculation numerous times on an iterative basis until a solution is found, e.g. the highest point on a curve, the lowest point on a curve etc. etc.. This use FOR 1 to 300 and NEXT statements. Once a figure is obtained it might well be used by another part of the programme. The programme is also interactive, allowing me to choose a suitable timber beam for instance from a selection that the programme has listed as satisfying all the stress criteria. Once I specify a joist size the programme continues and provides a detailed calculation, based on the section size chosen.
Can Excel be programmed in this way?
View 9 Replies
May 4, 2009
I am working with a excel file having some auto open macro,which process my data and file closes automatically. but during this whole operation the excel window appears on my desktop for about one second. I need this excel window must not appear and all operations in excel must be performed in background only so that i can save my processing time.
View 9 Replies
View Related
Apr 6, 2009
I'm running a sheet with three pieces of code (all blagged from these forums thank you) Two of the sub procedures have the same name "worksheet_change which generate an ambiguous name error. This I sort of understand. However I've tried changing the second one of the subs names to "worksheet_change1" and whilst the ambiguous name error goes away the sub routine then fails to function.
View 2 Replies
View Related
Dec 14, 2012
Is it possible to insert a formula or have a calculation performed for the range component when using the countif statement.
I am trying to take the entries in the rows in column B and divide its corresponding row in column A and then count how many meet a certain criteria.
View 1 Replies
View Related
Jul 22, 2014
Okay, I made an epic fail on a previous post that i turned to Solved, a real error on my part of not fully testing before i posted Solved, basically i was so excited that i'd solved it myself, well partially.
I have the following code in the first sub routine that collects which option button has been selected.
[Code] .....
The second sub routine is per following.
[Code] .......
Unfortunately when i tested this with only one variable myRev(1) it worked fine but when i added more myRev variables 2 thru 4 if failed, so is there a trick to passing an array variable between sub routines?
View 2 Replies
View Related
Jan 26, 2007
The first goes through a directory and opens all the files.. after it opens a given file it goes off into a sub-routine to process the data in that file.
I am trying to create a counter in the first sub-routine and then pass that value into the second sub-routine to tell it to put the values out on the next row down.. so the first time through it puts the values out on row 1, next time it puts them out on row 2, etc.
View 9 Replies
View Related