Re: Wstawienie tablicy do zakresu

Article View: pl.comp.lang.vbasic

Article #104913

Back to pl.comp.lang.vbasic Previous Next

#104913

From: ryszard.mikke
Date: Fri, 28 Sep 2012 12:23

20 lines
2116 bytes

W dniu piątek, 28 września 2012 14:02:08 UTC+2 użytkownik Bear napisał:
> 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 (:

Use the loop, Bera...

Technical Details

Message-ID: <b24afd35-f774-49c2-a393-ed5d4150feda@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!feeder2.cambriumusenet.nl!feed.tweaknews.nl!194.134.4.91.MISMATCH!news2.euro.net!209.197.12.242.MISMATCH!nx01.iad01.newshosting.com!newshosting.com!news-out.readnews.com!transit4.readnews.com!209.85.216.87.MISMATCH!l8no14417643qao.0!news-out.google.com!e10ni94578610qan.0!nntp.google.com!l8no14679730qao.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

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

Show Full Headers

Complete Article Headers

Received: by 10.224.189.75 with SMTP id dd11mr6498203qab.6.1348834996997;        Fri, 28 Sep 2012 05:23:16 -0700 (PDT)
Received: by 10.52.92.207 with SMTP id co15mr1623439vdb.9.1348834996965; Fri, 28 Sep 2012 05:23:16 -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!feeder2.cambriumusenet.nl!feed.tweaknews.nl!194.134.4.91.MISMATCH!news2.euro.net!209.197.12.242.MISMATCH!nx01.iad01.newshosting.com!newshosting.com!news-out.readnews.com!transit4.readnews.com!209.85.216.87.MISMATCH!l8no14417643qao.0!news-out.google.com!e10ni94578610qan.0!nntp.google.com!l8no14679730qao.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.lang.vbasic
Date: Fri, 28 Sep 2012 05:23:16 -0700 (PDT)
In-Reply-To: <ee42cec5-3c80-4d21-b6bb-e972761ee632@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=193.25.183.52; posting-account=Pfo6BgoAAABZkoNuIQQD7hT0S7pewFcp
NNTP-Posting-Host: 193.25.183.52
References: <ee42cec5-3c80-4d21-b6bb-e972761ee632@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <b24afd35-f774-49c2-a393-ed5d4150feda@googlegroups.com>
Subject: Re: Wstawienie tablicy do zakresu
From: ryszard.mikke@gmail.com
Injection-Date: Fri, 28 Sep 2012 12:23:16 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message