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 > > >