| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying formula to the bottom of a range
I'm trying to create a macro that copies a formula in a column down to the
bottom of a range. For example, I have data in columns A - L. In column M, I want to create a formula and copy it down to the bottom of my data. The only problem is my data is dynamic. One day it might end on row 1038, another day it might end on row 1152. Anyone have VBA code that can help me do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE | Excel Worksheet Functions | |||
| Copying a formula that contains a range of cell rows | Excel Discussion (Misc queries) | |||
| Problem copying formula to range of cells | Setting up and Configuration of Excel | |||
| Copying array formula to a range of cells... | Excel Programming | |||
| How to: Add blank row at bottom of range | Excel Programming | |||
![jeremy nickels[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
