I very New to VBA and am trying to find out how to take 2 values form the same row and different columns subtract them and give an output for that row. Then repeat that process for set range/ number of rows. I’m trying to make a timer that updates if any values are changed/ manually overwritten.

Im New to this so there’s probably a simple fix, I can get it to give the selected row I want but cant get it to give the column if I do .cells for example. Also all the named variables correspond correctly to a excel sheet. enter image description here