sum value of two range's

[Fyr]

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:

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!

 

[njimack]

Your current code is trying to write the result of the subtraction to a particular row, not a particular cell. Try this:

Sheets(ShName).Range("cz" & Rows.Count).End(xlUp).Offset(1,0).Value = Range("K6").Value - Range("I6").Value

 

[VoG]

Try without .Row

Sheets(ShName).Range("cz" & Rows.Count).End(xlUp) = Range("K6").Value - Range("I6").Value

 

[Fyr]

thank you both!!
Both of your fixes worked!