Tema: Re: excel help
Autorius: Eex
Data: 2011-04-01 14:31:22
aciu. bet vis tik su tuo macrosu patogiau kur kas, ir aiskiau.

"Donatas" <dnc@takas.lt> wrote in message 
news:in49g8$e4e$1@trimpas.omnitel.net...
> Prisegu pvz
>
> "Eex"  wrote in message news:in47uu$bbe$1@trimpas.omnitel.net...
>
> hm... tai lenteliu isdestyma galima keisti. man svarbu, kad rinktu 
> reiksmes
> persokdamas per fiksuota eiluciu skaiciu.
>
> "Donatas" <dnc@takas.lt> wrote in message
> news:in47p6$b1h$1@trimpas.omnitel.net...
>> eina, bet tada reikia keisti lenteliu isdestyma ir naudoti vlookup.
>> "Eex"  wrote in message news:in47av$a8m$1@trimpas.omnitel.net...
>> dekui, macrosas tikrai veikia (niekad nieko panasaus nesu naudojes).
>> o bet taciau, negi be makrosu neina? nemanau, kad cia as vienas su tokia
>> problema susiduriau...
>>
>> "Donatas" <dnc@takas.lt> wrote in message
>> news:in46hu$8sv$1@trimpas.omnitel.net...
>>> naudok makro komanda
>>>
>>> copy -> paste, veliau raides ir skaicius pasikeisk :)
>>>
>>> Dim i As Integer, j As Integer
>>> Sub abc()
>>> j = 60
>>> For i = 15 To 200
>>> Range("G" & i).Formula = "=B" & j
>>> j = j + 15
>>> Next i
>>> End Sub
>>>
>>>
>>> "Eex"  wrote in message news:in44h8$5m4$1@trimpas.omnitel.net...
>>>
>>> nu afiget, niekaip nesurandu kaip padaryti paprasta dalyka: braukiant
>>> zemyn,
>>> kad imtu reiksmes ne viena paskui kita, o persokdamas per fiksuota celiu
>>> skaiciu.
>>> net google nezinau kaip paklaust :)
>>>
>>>
>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>> signature database 6004 (20110331) __________
>>>
>>> The message was checked by ESET NOD32 Antivirus.
>>>
>>> http://www.eset.com
>>>
>>>
>>>
>>
>>
>> __________ Information from ESET NOD32 Antivirus, version of virus
>> signature database 6004 (20110331) __________
>>
>> The message was checked by ESET NOD32 Antivirus.
>>
>> http://www.eset.com
>>
>>
>>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus 
> signature database 6004 (20110331) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
> 


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