Re: Funkcja w VBA "licz jeżeli"

Article View: pl.comp.lang.vbasic

Article #103876

Back to pl.comp.lang.vbasic Previous Next

#103876

From: radoslaw85
Date: Wed, 26 Jun 2019 12:57

8 lines
1629 bytes

a czy tak nie prościej:

lastR = Cells(Rows.Count, 1).End(xlUp).Row

'możesz dodatkowo wynik wpisać sobie w jakąś komórkę:
Range("D1") = lastR

i odrazu wiesz ile masz wierszy, a to identyfikuje ci liczbę rekordów...

Technical Details

Message-ID: <aef8e398-50bf-4303-96fb-4561f10e26b8@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!takemy.news.telefonica.de!telefonica.de!weretis.net!feeder7.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!m24no2411546qtm.0!news-out.google.com!e20ni121qta.0!nntp.google.com!m24no2411543qtm.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

References: <5ca5f2c4-1fac-4e64-a684-2ace6f730962@k36g2000pri.googlegroups.com> <1gqg5i96xqw3n.stm8u70rrkfo$.dlg@40tude.net>

Show Full Headers

Complete Article Headers

X-Received: by 2002:aed:2241:: with SMTP id o1mr3585644qtc.233.1561553854707;        Wed, 26 Jun 2019 05:57:34 -0700 (PDT)
X-Received: by 2002:a05:620a:141a:: with SMTP id d26mr3813400qkj.32.1561553854626; Wed, 26 Jun 2019 05:57:34 -0700 (PDT)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!takemy.news.telefonica.de!telefonica.de!weretis.net!feeder7.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!m24no2411546qtm.0!news-out.google.com!e20ni121qta.0!nntp.google.com!m24no2411543qtm.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.lang.vbasic
Date: Wed, 26 Jun 2019 05:57:34 -0700 (PDT)
In-Reply-To: <1gqg5i96xqw3n.stm8u70rrkfo$.dlg@40tude.net>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=188.117.143.187; posting-account=sMtYPgoAAACR6oMjP02Pqm63SbX1c2AX
NNTP-Posting-Host: 188.117.143.187
References: <5ca5f2c4-1fac-4e64-a684-2ace6f730962@k36g2000pri.googlegroups.com> <1gqg5i96xqw3n.stm8u70rrkfo$.dlg@40tude.net>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <aef8e398-50bf-4303-96fb-4561f10e26b8@googlegroups.com>
Subject: Re: Funkcja w VBA "licz jeżeli"
From: radoslaw85@gmail.com
Injection-Date: Wed, 26 Jun 2019 12:57:34 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message