I'm trying to take two cell values, which are times, and do a subtraction equation. Then take the value of the subtraction and put it in the next available row in a column.
Here is what came up with so far, but it's not working:
Error i'm getting is
"Run-time error '450'
Wrong number of arguments or invalid property assignment"
thanks for taking a look!
Here is what came up with so far, but it's not working:
Code:
Sheets(ShName).Range("cz" & Rows.Count).End(xlUp).Row = Range("K6").Value - Range("I6").Value
Error i'm getting is
"Run-time error '450'
Wrong number of arguments or invalid property assignment"
thanks for taking a look!