Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to fill formula in any cell and drag it?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to fill formula in any cell and drag it?
Did you try recoding a macro ?
I got this: Range("C7").Select Application.CutCopyMode = False ActiveCell.FormulaR1C1 = "=SUM(R[-4]C:R[-1]C)" Range("C7").Select Selection.AutoFill Destination:=Range("C7:E7"), Type:=xlFillDefault Range("C7:E7").Select Selection.AutoFill Destination:=Range("C7:E10"), Type:=xlFillDefault Range("C7:E10").Select NickHK "vumian" wrote in message ... hi everyone, Please help me as following: - i wanna use VBA to fill automatically a formula in any cell i don't 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 last row -4. thanks in advance. -- vumian ------------------------------------------------------------------------ vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494 View this thread: http://www.excelforum.com/showthread...hreadid=570009 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to fill formula in any cell and drag it?
hi man, thanks for your help, but i mean, i drag down to last rows-4. it does not mean to drag down row thanks for help one more -- vumia ----------------------------------------------------------------------- vumian's Profile: http://www.excelforum.com/member.php...fo&userid=3649 View this thread: http://www.excelforum.com/showthread.php?threadid=57000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill & Drag to Right !! HELP ! | Excel Discussion (Misc queries) | |||
fill handle and cell drag-and-drop | Excel Discussion (Misc queries) | |||
Fill Handle doesn't display - Allow cell drag and Drop option is c | Excel Discussion (Misc queries) | |||
Drag to fill a formula - problem! | Excel Worksheet Functions | |||
How to avoid black shade fill on the from cell,when drag-and-drop | New Users to Excel |