Re: Nascondere riga in Excel con Vba

Article View: free.it.visual-basic

Article #752

Back to free.it.visual-basic Previous Next

#752

From: Davide
Date: Sun, 06 Mar 2005 15:40

25 lines
1759 bytes

"Giorgio" <internetnostop@aliceposta.it> ha scritto nel messaggio
news:nkIQd.903345$35.34088245@news4.tin.it...
> Per cortesia,
> vi � la possibilita tramite formula o Vba di nascondere una riga se una
> cella � priva di dati tenendo presente che se invece li contiene si deve
> vedere?
Se, ad esempio, non vuoi far vedere la riga 5, a meno che la cella(E5) non
sia occupata da qualche dato, il codice puo' essere qualcosa del tipo:

    If Cells(5, 5) = "" Then
        Rows("5:5").Select
        Selection.EntireRow.Hidden = True
    Else
        Rows("5:5").Select
        Selection.EntireRow.Hidden = flase
    End If


> Grazie 1000 e saluti
>
> Giorgio

Prego.
Ciao.
Davide.

Technical Details

Message-ID: <TvFWd.625328$b5.28505937@news3.tin.it>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!news.wiretrip.org!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!news-out.tin.it!news-in.tin.it!news3.tin.it.POSTED!not-for-mail

References: <nkIQd.903345$35.34088245@news4.tin.it>

Show Full Headers

Complete Article Headers

X-Google-Thread: f94ee,f40c5c3e2337f95e
X-Google-Attributes: gidf94ee,public
X-Google-Language: ITALIAN,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!news.wiretrip.org!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!news-out.tin.it!news-in.tin.it!news3.tin.it.POSTED!not-for-mail
From: "Davide" <nospam@nospam.it>
Newsgroups: free.it.visual-basic
References: <nkIQd.903345$35.34088245@news4.tin.it>
Subject: Re: Nascondere riga in Excel con Vba
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Message-ID: <TvFWd.625328$b5.28505937@news3.tin.it>
Date: Sun, 06 Mar 2005 15:40:35 GMT
NNTP-Posting-Host: 80.181.125.34
X-Complaints-To: "Please send abuse reports to abuse@tin.it and technical notifications to newsmaster@tin.it"
X-Trace: news3.tin.it 1110123635 80.181.125.34 (Sun, 06 Mar 2005 16:40:35 MET)
NNTP-Posting-Date: Sun, 06 Mar 2005 16:40:35 MET
Organization: TIN

Reply to Parent Message