Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill function to next cells
I have a macro that requires functions in the adjacent cells filled right
every month. So for example cells A10 to A15 need to be copied to cells B10 to B15 this month. But next month the cells from B10 to B15 will need to be copied to cells C10 to C15. So what I want to do is find the correct cell and then: ActiveCell.Select Selection.Resize(5, 1).Select But then how do I fill these selected cells right? Help will be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function in cell than fill to next 5 column cells. | Excel Programming | |||
color fill cells based on IF function or formula | Excel Worksheet Functions | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
Help using the 'If' function to automatically fill in other cells | Excel Worksheet Functions | |||
Function to automatically fill in an array of cells | Excel Programming |