Macro to paste from clipboard
On 03/08/2015 11:20, Claus Busch wrote:
Hi again,
Am Mon, 3 Aug 2015 10:52:48 +0100 schrieb F:
Is there a solution which ignores the presence of the data in A36:E40
and so start writing in C4:F4 (the first empty area above A36:E40) and
then subsequent rows?
if you run the macro every day you could create the row with the day:
Set dest = .Cells(Day(Date) + 3, 3)
Regards
Claus B.
Hi
And thanks again.
Trying hard to educate myself... would
Set dest = Range("C36").End(xlUp)(2)
do what I want?
Regards
--
Frank
|