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