Copy multi-line variable to first empty row
Hi Terry,
Am Wed, 29 Jan 2020 21:26:51 +0000 schrieb Terry Pinnell:
One minor point that probably has a simple answer; did you notice that
the entries in cols N, O and P are red? The cols are not formatted with
red font so I'm puzzled.
some of your cells are formatted.
Insert a line into the code (after LRow=...)to clear the formats:
LRow = .Cells(.Rows.Count, "A").End(xlUp).Row + 1
..Rows(LRow).ClearFormats
What kind of file is your source and what is the name of it?
Perhaps there is an easier way without the clipboard.
Regards
Claus B.
--
Windows10
Office 2016
|