View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Copy multi-line variable to first empty row

Hi Terry,

Am Fri, 31 Jan 2020 16:45:33 +0000 schrieb Terry Pinnell:

Thanks Claus but that gives Run-time error '13': Type mismatch
And this line is highlighted
.Cells(LRow, varCols(i)) = Format(DateValue(strDate), "dddd
dd\/mm\/yy")


have another look. For me it works fine.

There is only one problem with the system language.
I have to change July to Juli.


Regards
Claus B.
--
Windows10
Office 2016