Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I want to know how can we use the same formula in all the new cells inserted, programatically in VBA. For example: i have a formula for the cell D1 as (A1+B1+C1)/3 .now suppose i insert a new cell D5 i want the same formula to be there for this cell also which should be (A5+B5+C5)/3. Is it possible to do it programatically? Could anyone look into this as soon as possible? Awaiting for the reply Regards, Padmaja ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make Control-Home go immediately to A1? | Excel Discussion (Misc queries) | |||
Fill in Blanks with immediately above cell value | Excel Discussion (Misc queries) | |||
Immediately jump to next cell? | Excel Discussion (Misc queries) | |||
Workbook Unexpectedly Closes Immediately | Excel Discussion (Misc queries) | |||
Change cell value immediately after a save | Excel Programming |