Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


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

Re: Copy multi-line variable to first empty row

From Terry Pinnell <me@somewhere.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Copy multi-line variable to first empty row
Message-ID <dv293ftboc5q2415mek08udji2c4emfdur@4ax.com> (permalink)
References (8 earlier) <r11jpm$tq$1@dont-email.me> <bgm83fhv8h9ajkun4iplmjcfqfsl559j21@4ax.com> <r11osr$30t$1@dont-email.me> <tjr83fhegta6d9e5a9p0jondjineb5msb0@4ax.com> <r11s6d$ns1$1@dont-email.me>
Organization Forte - www.forteinc.com
Date 2020-01-31 20:24 +0000

Show all headers | View raw


Claus Busch <claus_busch@t-online.de> wrote:

>Hi Terry,
>
>Am Fri, 31 Jan 2020 18:31:33 +0000 schrieb Terry Pinnell:
>
>> I'm still struggling to find what I'm doing wrongly with Claus's last
>> code, but I think I'll put it aside for now and retire to the lounge for
>> a glass of white ;-)
>
>you get the error when the cipboard is empty.
>
>
>Regards
>Claus B.

Hi Claus & Garry,

I methodically reduced the growing clutter of modules and procedures to
a minimum: just your macro and the 'clipboard overhead'. Then I tried
again. Still same result!

Here is my latest worksheet:
https://www.dropbox.com/s/p06jmcvnhesk8pm/WalkIndexLatestTest.xlsm?raw=1

The data for clipboard remains the same, but for convenience here it is
again:

20190919MarshGreen-B-r424-m4.4.gpx
Circular walk with Brian, Marsh Green
20190919MarshGreen-B-r424-m4.4
Thursday 19 September 2019
20190919
09:56
11:53
1:56
4.5
2.3
424
242
190
190
Thursday 19 September 2019: Circular walk with Brian, Marsh Green
Start 09:56, End 11:53,  Dur'n 1:56 , 4.5 miles, avg. mph 2.3
Gross asc/desc 190 ft, Max 242 ft
C:\Users\terry\Dropbox\FinishedWalks\20190919MarshGreen-B-r424-m4.4.jpg
C:\Users\terry\Dropbox\FinishedWalks\20190919MarshGreen-B-r424-m4.4-PS.jpg
D:\Pictures\PHOTOS\Walks UK\2019\20190919-110750.jpg
30 January 2020

Terry, East Grinstead, UK

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


Thread

Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-29 11:21 +0000
  Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-01-29 14:44 +0100
    Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-29 17:49 +0000
      Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-01-29 20:27 +0100
        Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-29 21:26 +0000
          Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-01-30 06:44 +0100
            Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-30 13:38 +0000
              Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-01-31 00:11 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 09:23 +0000
            Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-30 17:40 +0000
            Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-30 21:18 +0000
              Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-30 17:24 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 11:20 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 11:14 -0500
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 11:56 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 17:26 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 12:41 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 18:31 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-01-31 19:38 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 18:59 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 14:14 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 19:51 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 16:59 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 23:09 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 18:32 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-01 07:17 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-02-01 07:46 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-01 17:36 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-02-01 12:49 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-03 07:24 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 20:07 -0500
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 17:16 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 23:21 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 18:50 -0500
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 19:05 -0500
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 20:24 +0000
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 20:35 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-01-31 21:43 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 22:53 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-02-01 01:33 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-01 07:59 +0000
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-01 12:50 +0000
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-01 14:12 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-02-02 17:44 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-02 18:42 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-02-02 19:46 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-02 19:32 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-02-02 21:17 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-02 21:10 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-02-02 22:16 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-02 22:38 +0000
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-03 18:18 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-02-03 19:40 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-03 21:23 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-02-03 22:28 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-03 21:37 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-02-04 16:41 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-04 17:01 +0000
                Re: Copy multi-line variable to first empty row GS <gs@v.invalid> - 2020-01-31 14:11 -0500
              Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-01-31 13:27 +0100
                Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-01-31 16:45 +0000
                Re: Copy multi-line variable to first empty row Claus Busch <claus_busch@t-online.de> - 2020-01-31 18:13 +0100
  Re: Copy multi-line variable to first empty row Terry Pinnell <me@somewhere.invalid> - 2020-02-12 13:30 +0000

csiph-web