Tema: Re: excel help
Autorius: Donatas
Data: 2011-04-01 13:30:32
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
>
>
>