Setting these variables doesn't seem to make a difference because I think the issue is where I am taking long numbers from my sheet (attached)
"Error Code '6' Overflow" pops up when I change certain CLng() in to CDbl(). For example below for aluminium layer I swapped a few CLng to CDbl and that was fine but for air bubble layer it pops up with error code. (Even though it is literally the same code 'copy and pasted' but with different cells utilised in the calculations). The cells utilised in Air bubbles use a decimal point so I thought that line of code would be more likely to need CDbl()
If I change the air bubble cell with a decimal place for some reason it pops up with "Error Code '6' Overflow" further down.
Bookmarks