recursive programming

Hello everyone and greetings! I have concocted a procedure to control two (2) clocks for a chess game. On a sheet, I have 2 cells that contains the cumulative time spent by each player; I also have 2 buttons that each player must push in turn once their move is completed. Pushing one button...

Hey guys, I'm trying to learn how to use factorials, this is a simple example: Option Explicit Function factorials(nr As Long, Optional factorialsTest As Long = 1) Dim test As Variant factorialsTest = nr * factorialsTest nr = nr - 1 If nr <> 0 Then Call factorials(nr, factorialsTest) test =...

Morning! So I have a parent folder (labeled "2017") with some subfolders (Labeled "Month 1", "Month 2", etc etc) and some subfolders (labeled "Week 1", "Week 2", etc etc) in the Month folders. The Week folders also have some subfolders, i.e. "Completed", and some other non-important folders. I...

I have a collection of CSV files in a set of subfolders and a main (but empty) file that contains formatting (column widths, colors and cell merges). I would like to copy the formatting from the formatting template xlsx file to each csv file then save the csv file as an xlsx file. I've got the...

Let's call the numbering system in column 1 a work breakdown structure (WBS) or hierarchical taxonomy. There is no fixed number of elements below a top level, There is no fixed number of sub-indents. Therefore, the maximum length of 'Number' field is variable and unknown. I am attempting...

Folks, I want to build a macro that will load up a VBA macro (permutations()) with all the combinations of x items from a list of y possible items. To start out, I'm trying for all combinations of 4 from a list of 10. I know that I can do nested for loops, but I want a dynamic macro. I'm...