| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formula with a Macro
What is a simple way (in a macro) to copy a formula down an empty column and
only paste the formula if data exists on that row? I've used {Worksheets("Sheet1").Range("A1:A100").FillDown} when I know how many rows have data, but in this case I don't have any idea how many rows there may be with data. Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a Formula in a Macro | Excel Discussion (Misc queries) | |||
| Copy down formula macro | Excel Worksheet Functions | |||
| Use Macro to Copy Formula from one Workbook to another | Excel Discussion (Misc queries) | |||
| Copy a formula down in a macro | Excel Discussion (Misc queries) | |||
| Copy Formula Macro | Excel Programming | |||
Threaded Mode
