hi everyone,

Please help me as following:
- i wanna use VBA to fill automatically a formula in any cell i don'
know before
- then, drag that cell to right 2 cells more
- after that, select 3 cells, drag all of them down to last row - 4
because amount of rows update frequently. last row of formula is las
row -4.

thanks in advance

--
vumia
-----------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...fo&userid=3649
View this thread: http://www.excelforum.com/showthread.php?threadid=57000