| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto fill a list with a formula
I recorded this macro, and of course it does what it's asked.
'Inserts a formula in column H to calculate Amount Range("H2").Select ActiveCell.FormulaR1C1 = "=RC[-3]*RC[-1]" Selection.AutoFill Destination:=Range("H2:H65000") Range("A2").Select To improve this macro, I was hoping to modify it so it only copied down the list (no matter what size the list is) - not down to row 65,000. How would I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto fill or auto search from a list or drop-down list??????? | Excel Discussion (Misc queries) | |||
| Auto fill/list | Excel Discussion (Misc queries) | |||
| Auto fill from pick list | Excel Worksheet Functions | |||
| Drop Down List & Auto Fill | New Users to Excel | |||
| Auto-Fill in List Fields? | Excel Worksheet Functions | |||
Threaded Mode
