zadnja popunjena kolona

zadnja popunjena kolona 06.01.2020. u 10:59 · pre 83 meseca #1

Kako da nađem zadnju popunjenu kolonu u drugom redu

Našao sam kod koji određuje broj poslednjeg popunjenog reda u koloni A
xy = Sheets("Sheet1").Range("A10000").End(xlUp).Row 'broj poslednjeg popunjenog reda

Meni treba broj poslednje popunjene kolone u drugom redu

Pokušao sam da prilagodim gornji kod ali bez uspjeha

Re: zadnja popunjena kolona 06.01.2020. u 12:30 · pre 83 meseca #2

Pokušaj sa:

Code:

Cells(2,Sheet1.Columns.Count).End(xlToLeft).Column

Takođe, ovo je moguće i formulom, npr:

Code:

=LOOKUP(2;1/N(LEN($2:$2));COLUMN($2:$2))

_{[Edit: unete ispravke.]}

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

Re: zadnja popunjena kolona 06.01.2020. u 22:50 · pre 83 meseca #3

Hvala 3okc
Kod pronalazi broj prazne kolone, ali ja nisam uspio da to ubacim u svoj kod.
U prilogu šaljem primjer sa kodom da ga izmijenite ako može.

Book1.xls35k

Re: zadnja popunjena kolona 07.01.2020. u 21:20 · pre 83 meseca #4

Probaj sa ovim, bez kopi/pejst:

Code:

Sub Prenesi()
Dim rngUL As Range
Dim rngIZ As Range

Set rngUL = Sheets("RN").Range("E2:E20")
Set rngIZ = Sheets("izlaz").Cells(2, Columns.Count).End(xlToLeft).Resize(rngUL.Rows.Count).Offset(, 1)

rngIZ.Value = rngUL.Value
End Sub

Potpis

Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!

Re: zadnja popunjena kolona 08.01.2020. u 08:16 · pre 82 meseca #5

Radi odlično

Hvala

Forum kao aplikacija na telefonu

Srodne teme