skip9999
05-09-2018, 10:35 PM
Good morning all,
I'm new to the forum and a novice when it comes to VBA.
I'm currently tasked with calculating the thickness of material [anything containing RBL (rubble)] in a samples, however the calculation should terminate when the first SST or CNG (sandstone or conglomerate) is encountered. The forumula will the have to loop down the worksheet. An example is attached as a jpeg.
I have ten of thousands of rows to calculate.
Any advice or assistance will be greatly appreciated.
Thanks,
Andy
I'm new to the forum and a novice when it comes to VBA.
I'm currently tasked with calculating the thickness of material [anything containing RBL (rubble)] in a samples, however the calculation should terminate when the first SST or CNG (sandstone or conglomerate) is encountered. The forumula will the have to loop down the worksheet. An example is attached as a jpeg.
I have ten of thousands of rows to calculate.
Any advice or assistance will be greatly appreciated.
Thanks,
Andy