[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4688: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4690: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4691: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4692: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
Matjazev.NET • Poglej temo - Barvno označevanje celic



..|| Blog || Produkti/Storitve || MExcel || MDodatki || 300 nasvetov ||..

Barvno označevanje celic

Pomoč pri delu z MS Excelom

Barvno označevanje celic

OdgovorNapisal/-a 666angel » To maj 07, 2019 11:10 am

Pozdravljeni

Ali je možno v excelu narediti "funkcijo" da če je v izbranem območju (B5:DS5) katera koli celica obarvana zeleno, potem obarva celico "A5" v zeleno. Naj omenim da se celice pobarvajo ročno in ni formule za "barvanje"
666angel
 
Prispevkov: 17
Pridružen: Sr avg 19, 2015 12:43 pm



Matjazev.NET
 

Re: Barvno označevanje celic

OdgovorNapisal/-a admin » To maj 07, 2019 11:31 am

lp,
Matjaž Prtenjak
Administrator
admin
Site Admin
 
Prispevkov: 3566
Pridružen: Sr jul 20, 2005 10:06 pm

Re: Barvno označevanje celic

OdgovorNapisal/-a 666angel » To maj 07, 2019 1:10 pm

Pozdravljeni

Hvala za hiter odgovor, obseg celic in celico ki naj bi obarvalo sem spremenil na ("B10:DS10") in "a10", vendar naletim na težavo ko napišem makro - v vrstici " Range("a10").Interior.Color = zelena " javi napako
Kaj bi lahko bil vzrok?
666angel
 
Prispevkov: 17
Pridružen: Sr avg 19, 2015 12:43 pm

Re: Barvno označevanje celic

OdgovorNapisal/-a admin » To maj 07, 2019 1:44 pm

:) Brez da napišete besedilo napake in priložite točen makro, kot ste ga napisali vam ne morem nič pomagati :(.

Kako a naj vem kakšno napako vam javi?
lp,
Matjaž Prtenjak
Administrator
admin
Site Admin
 
Prispevkov: 3566
Pridružen: Sr jul 20, 2005 10:06 pm

Re: Barvno označevanje celic

OdgovorNapisal/-a 666angel » To maj 07, 2019 1:56 pm

se opravičujem
Napaka je:
Run-time error 1004
Application defined or object defined error

ko kliknem na "debug" mi rumeno obarva vrstico "Range("a10").Interior.Color = zelena "

Makro pa se glasi:
Sub obarvaj()
Dim zelena As Long: zelena = 52480

Dim celica
For Each celica In Range("B10:DS10")
If (celica.Interior.Color = zelena) Then
Range("a10").Interior.Color = zelena
End If
Next
End Sub
666angel
 
Prispevkov: 17
Pridružen: Sr avg 19, 2015 12:43 pm

Re: Barvno označevanje celic

OdgovorNapisal/-a admin » To maj 07, 2019 3:08 pm

Kam pa ste vi to kodo vpisali? S samo kodo namreč nič narobe!

Ali sto jo skopirali v nek modul v VBA urejealniku, kot je to opisano recimo med nasveti:
lp,
Matjaž Prtenjak
Administrator
admin
Site Admin
 
Prispevkov: 3566
Pridružen: Sr jul 20, 2005 10:06 pm


Vrni se na Excel

Kdo je prisoten

Po forumu brska: 0 registriranih uporabnikov in 5 gostov

cron