Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #107935
| Subject | Re: Macro to paste from clipboard |
|---|---|
| References | <t7-dnW0Rv_aewibInZ2dnUU78audnZ2d@brightview.co.uk> <mpi2a4$ng$1@dont-email.me> <sP2dnaTfVJ-jpyLInZ2dnUU78LmdnZ2d@brightview.co.uk> <mpnf5q$8v5$1@dont-email.me> |
| Newsgroups | microsoft.public.excel.programming |
| From | F <news@nowhere> |
| Date | 2015-08-03 12:01 +0100 |
| Message-ID | <98CdnWBxntDR1yLInZ2dnUU78dOdnZ2d@brightview.co.uk> (permalink) |
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
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Re: Macro to paste from clipboard Claus Busch <claus_busch@t-online.de> - 2015-08-01 11:09 +0200
Re: Macro to paste from clipboard F <news@nowhere> - 2015-08-03 10:52 +0100
Re: Macro to paste from clipboard Claus Busch <claus_busch@t-online.de> - 2015-08-03 12:07 +0200
Re: Macro to paste from clipboard Claus Busch <claus_busch@t-online.de> - 2015-08-03 12:12 +0200
Re: Macro to paste from clipboard Claus Busch <claus_busch@t-online.de> - 2015-08-03 12:20 +0200
Re: Macro to paste from clipboard F <news@nowhere> - 2015-08-03 12:01 +0100
Re: Macro to paste from clipboard Claus Busch <claus_busch@t-online.de> - 2015-08-03 13:12 +0200
csiph-web