Tema: Excel VBE kabutes
Autorius: ZRimaZ
Data: 2009-10-19 16:23:17
Sveiki

Uzsiciklinau truputi...

VBE reikia padaryti paprasta veiksma: i Project!C37 i rasyti formule

=SUMIF(material_all!$E$3:$E$175;TEXT(config!A45;"#");material_all!$R$3:$R$175)+SUMIF(material_all!$E$3:$E$175;TEXT(config!A46;"#");material_all!$R$3:$R$175)

Kaip ir paprasta butu, bet visa problema su " - kaip jas parasyti, kad VBE 
nesikeiktu?

Sitoks parasymas negelbsti - klaida 1004....
Worksheets("Project").Range("C37").Formula = 
"=SUMIF(material_all!$E$3:$E$175;TEXT(config!A45;""#"");material_all!$R$3:$R$175)+SUMIF(material_all!$E$3:$E$175;TEXT(config!A46;""#"");material_all!$R$3:$R$175)"

Dekui
3Dastronomyagricultureaudioautosautos.audiautos.audioautos.binariesautos.bmwautos.clubautos.fordautos.hondacrxautos.japanautos.mercedesautos.opelautos.sportautos.volvoautos.vwaviaavia.binariesbankcardsbinariesbooksbuildingcinemacommercecomp.hardwarecomp.softwarecomp.lietuvinimascomp.networksculturedarbas.ieskaudarbas.siulaudesigneconomicselectronicsfaunafauna.aquafauna.binariesfishingflorafotofoto.binariesgamesgames.csgames.onlinegsmgurmanaihumourhumour.binariesinternetlawmicrosoftmotomusicmusic.binariesmusic.instrumentsmusic.LT.binariesnavigacijaphppoliticsprogrammingrpgsportstudyingsveikatatalktesttranslationtransportationtraveltravel.binariestvunixvideovideo.binarieswatersportswwwwww.flashpdaautos.supermama.ltmobiledarbasretro.3Dretro.agricultureretro.astronomyretro.audioretro.autosretro.autos.audiretro.autos.audioretro.autos.binariesretro.autos.bmwretro.autos.clubretro.autos.fordretro.autos.hondacrxretro.autos.japanretro.autos.mercedesretro.autos.opelretro.autos.sportretro.autos.supermamaretro.autos.supermama.ltretro.autos.volvoretro.autos.vwretro.aviaretro.avia.binariesretro.bankcardsretro.beosretro.binariesretro.booksretro.buildingretro.cinemaretro.commerceretro.compretro.comp.hardwareretro.comp.lietuvinimasretro.comp.networksretro.comp.softwareretro.cultureretro.darbasretro.darbas.ieskauretro.darbas.siulauretro.designretro.economicsretro.electronicsretro.e-vejasretro.faunaretro.fauna.aquaretro.fauna.binariesretro.fishingretro.floraretro.fotoretro.foto.binariesretro.gamesretro.games.csretro.games.onlineretro.games.rpgretro.genealogijaretro.gsmretro.gurmanairetro.humourretro.humour.binariesretro.internetretro.YZFretro.YZF.nebukretro.YZF.nebuk.netikintisretro.YZF.nebuk.netikintis.bukretro.YZF.nebuk.netikintis.buk.tikintisretro.lawretro.microsoftretro.mobileretro.motoretro.musicretro.music.binariesretro.music.instrumentsretro.music.LTretro.music.LT.binariesretro.navigacijaretro.newsretro.news.taisyklesretro.newuserretro.pdaretro.phpretro.politicsretro.programmingretro.rpgretro.sportretro.studyingretro.sveikataretro.talkretro.translationretro.transportationretro.travelretro.travel.binariesretro.tvretro.unixretro.videoretro.video.binariesretro.watersportsretro.wwwretro.www.flashdiylt.rkm.news.announcelt.rkm.news.newuser
+Q: kuom remontuotPjero2009-10-23 11:19
+kame stabdymo saknysm.k.2009-10-23 08:12
+Win7 vopros na zasypku:)Toxis@ze_yvil_place2009-10-22 14:07
+Reikalingas XP OEM veikiantis raktas.dp2009-10-22 11:22
+siukslina kompasUredija2009-10-22 10:17
+Q:kaip istrinti firefoxe puslapio laukelyje"qery" konkrecia "isiminta reiksme"John Smith2009-10-22 09:08
+q: nauja gelezis + sena PI?liuc_2009-10-22 08:43
+ppt -> swfVegys2009-10-21 14:17
+Antivirusines seniems kompamsmdz2009-10-21 13:53
+Kaip pataisyti HBCD wintools bat failą?Vytooks2009-10-21 09:53
+Software turbinimasnu blyn2009-10-21 07:53
+WRT54GL + Tomato FW manualShadowed2009-10-20 23:17
+Sound editing software - preffered freeJornada Del Muerto2009-10-20 20:20
+Klausimas: excelsaugas2009-10-19 16:43
-Excel VBE kabutesZRimaZ2009-10-19 16:23
Re: Excel VBE kabutesCurrentUser2009-10-19 17:33
Re: Excel VBE kabutesZRimaZ2009-10-19 17:49
Re: Excel VBE kabutesCurrentUser2009-10-19 19:13
+spelling office 2003m.k.2009-10-19 14:24
Q: google apeidineja kazkokia nesamoneservisas2009-10-19 12:13
Koduotės keitimaswiedras2009-10-19 11:58
+Q:Nod32 neatsidaro - pasislepe...raibutis2009-10-19 08:53
+NERO burning romaaa2009-10-19 04:43
REQ: Video softoShadowed2009-10-18 19:27
+Neveikia regeditpablas2009-10-18 10:26
poker play visit 2009-10-18 07:41
req: keyloggerio linuxams.Shlipsas2009-10-18 02:33
+Office 2000LabaiNeSpauda2009-10-17 21:44
+WinXP SP3 WGACurrentUser2009-10-17 21:15
+del LinkomanijosDainius2009-10-17 20:59
+Kaip karpyti video?Sigitas2009-10-17 19:54
+Video ripinimasBull2009-10-17 15:47
+Reikia vaistu Sketchup Pro 7.1pablas2009-10-17 13:11
+Teisiu apribojimas Windows 7Velnias2009-10-16 18:36
REQ sofro OMVL DREAM XXI Npjezo2009-10-16 09:48
+Opera uzhknisti bandoSALVIKAZ2009-10-16 09:14
OT: autocad 2010 vadovelispablas2009-10-16 09:06
+Windows RegEdit<nera@mailo.lt>2009-10-16 07:44
+Q: Proofing Tools for Office '07grn2009-10-15 22:09
+Su kokia programa padaryta diagrama?Gugis <gugenojus@gmail.com>2009-10-15 17:38
+Q: ESET Smart Security LoginViewer alternatyva?Mindaugas2009-10-15 11:21
+REQ: Excel, kaip padaryti išranką iš sąrašo?Aras2009-10-14 15:00
+Norton internet security 2009asdf2009-10-14 10:27
+REQ: pagalbos su exeliuLaidas2009-10-14 10:02
+Outlook express notifierDriven2009-10-14 09:33
+Kuri Skype versija geriausia?700052009-10-13 18:50
+Freeware piesimo programosJornada Del Muerto2009-10-12 20:05