Posting code with IF
The following code is only part of larger posting process. I require
assistance for this posting to be done only if DG77 is NOT i.e. there must
be value, zero is not a value. Additional info, the formula in DG77 is
=IF($DF$8=1,$DF$3,) DF3 has a positive number all the time.
Set CopyRng = _
Sheets("Sheet2").Range("DG77", "DH77")
Set DestRng = _
Sheets("Sheet1").Cells(65536, "F").End(xlUp).Offset(1, 0)
i = 0
For Each cell In CopyRng
DestRng.Offset(0, i).Value = cell
i = i + 2
Next
Similar postings (without conditions) take place before and after
the process above.
Thank you.
--
Robert
|