Groups > microsoft.public.excel.programming > #107936

Re: Macro to paste from clipboard

From	Claus Busch <claus_busch@t-online.de>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Macro to paste from clipboard
Date	2015-08-03 13:12 +0200
Organization	A noiseless patient Spider
Message-ID	<mpni7s$jpe$1@dont-email.me> (permalink)
References	<t7-dnW0Rv_aewibInZ2dnUU78audnZ2d@brightview.co.uk> <mpi2a4$ng$1@dont-email.me> <sP2dnaTfVJ-jpyLInZ2dnUU78LmdnZ2d@brightview.co.uk> <mpnf5q$8v5$1@dont-email.me> <98CdnWBxntDR1yLInZ2dnUU78dOdnZ2d@brightview.co.uk>

Show all headers | View raw

Hi Frank,

Am Mon, 3 Aug 2015 12:01:17 +0100 schrieb F:

> Trying hard to educate myself... would
> Set dest = Range("C36").End(xlUp)(2)
> do what I want?

not if you have data in C1:C40.
Then it will find C41


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Find similar | Unroll thread

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