Wstawienie tablicy do zakresu

Article View: pl.comp.lang.vbasic

Article #104907

Back to pl.comp.lang.vbasic Previous Next

#104907

From: Bear
Date: Fri, 28 Sep 2012 12:02

9 lines
1853 bytes

Mam taki kod:
--------------------------------------------------------------------------
Dim Parametry As Variant
Parametry = Array("Time", "tzewn", "tzas_msc", "tpow_msc")
Range("A1:D1").Value = Application.WorksheetFunction.Transpose(Parametry)
--------------------------------------------------------------------------
Wstawienie skutkuje wypełnieniem całego zakresu A1:D1 pierwszym elementem z tablicy. Jak wypełnić zakres prawidłowymi elementami tablicy?

Dzięki za wszelkie sugestie (:

Technical Details

Message-ID: <ee42cec5-3c80-4d21-b6bb-e972761ee632@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin2!goblin.stu.neva.ru!xlned.com!feeder7.xlned.com!news2.euro.net!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!l8no14626741qao.0!news-out.google.com!e10ni94578610qan.0!nntp.google.com!l8no14626736qao.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

Received: by 10.224.181.83 with SMTP id bx19mr6435461qab.1.1348833728400;        Fri, 28 Sep 2012 05:02:08 -0700 (PDT)
Received: by 10.236.143.241 with SMTP id l77mr1299774yhj.10.1348833728339; Fri, 28 Sep 2012 05:02:08 -0700 (PDT)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin2!goblin.stu.neva.ru!xlned.com!feeder7.xlned.com!news2.euro.net!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!l8no14626741qao.0!news-out.google.com!e10ni94578610qan.0!nntp.google.com!l8no14626736qao.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.lang.vbasic
Date: Fri, 28 Sep 2012 05:02:08 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=212.33.81.250; posting-account=phv_zwoAAADWlIItqWRLEQipwamV29aK
NNTP-Posting-Host: 212.33.81.250
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ee42cec5-3c80-4d21-b6bb-e972761ee632@googlegroups.com>
Subject: Wstawienie tablicy do zakresu
From: Bear <bear4@poczta.onet.pl>
Injection-Date: Fri, 28 Sep 2012 12:02:08 +0000
X-Received-Bytes: 1536
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit