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