you are welcome.
first declare a variable which will hold the last non blank cell's row number
you can find the last blank non cell in column A like this:
LastRow = dWS.Cells(Rows.Count, "A").End(xlUp).Row
or
LastRow = dWS.Cells(Rows.Count, 1).End(xlUp).Row
or
LastRow = dWS.Range("A" & Rows.Count).End(xlUp).Row
(Rows.Count gives total nuımber of rows in a worksheet. Range("A" & Rows.Count) = Range("A1048576"))
so first blank cell in colum A is LastRow + 1
ex1 will be
dWS.Range("A" & LastRow + 1).Value = sWS.Range("Z24").Value
or you can directly assign the row number of first non blank cell in column A
LastRow = dWS.Range("A" & Rows.Count).End(xlUp).Offset(1,0).Row
then
dWS.Range("A" & LastRow).Value = sWS.Range("Z24").Value