Re: Wiele arkuszy w Exceclu (VBA)

Article View: pl.comp.lang.vbasic

Article #92667

Back to pl.comp.lang.vbasic Previous Next

#92667

From: Wojciech Zych
Date: Sun, 06 Nov 2005 16:12

11 lines
1104 bytes

Czesc,

Moze tak:

ile_zakladek = ThisWorkbook.Worksheets.Count
i = 1
Do While i <= ile_zakladek
     ThisWorkbook.Worksheets(i).Activate
     Makro
     i = i + 1
Loop

Technical Details

Message-ID: <dkla18$d5a$1@atlantis.news.tpi.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail

References: <2b97.0000084f.436e0ae0@newsgate.onet.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail
From: Wojciech Zych <wjzych@poczta.onet.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: Re: Wiele arkuszy w Exceclu (VBA)
Date: Sun, 06 Nov 2005 17:12:16 +0100
Organization: tp.internet - http://www.tpi.pl/
Lines: 11
Message-ID: <dkla18$d5a$1@atlantis.news.tpi.pl>
References: <2b97.0000084f.436e0ae0@newsgate.onet.pl>
NNTP-Posting-Host: k002.dnet.pl
Mime-Version: 1.0
X-Trace: atlantis.news.tpi.pl 1131293545 13482 213.25.199.2 (6 Nov 2005 16:12:25 GMT)
X-Complaints-To: usenet@tpi.pl
NNTP-Posting-Date: Sun, 6 Nov 2005 16:12:25 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl-PL; rv:1.7.12) Gecko/20050915
X-Accept-Language: pl, en-us, en
In-Reply-To: <2b97.0000084f.436e0ae0@newsgate.onet.pl>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Reply to Parent Message