| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying to a flexible range
I want to copy a formula using a macro but the ending part of the range can
change. For example, the user inputs the current age and a retirement age and the retirement age can change. How do I create a macro that can allow the range to be flexible, i.e. 15 years, 20 years, etc. I can copy the formula manually to the ending range but I want to be able to have a macro perform this automatically. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying to a flexible range
lastrow=cells(rows.count,"a").end(xlup).row range("b12").copy range("a"&lastrow) -- Don Guillett Microsoft MVP Excel SalesAid Software "johncpa" wrote in message ... I want to copy a formula using a macro but the ending part of the range can change. For example, the user inputs the current age and a retirement age and the retirement age can change. How do I create a macro that can allow the range to be flexible, i.e. 15 years, 20 years, etc. I can copy the formula manually to the ending range but I want to be able to have a macro perform this automatically. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED A FLEXIBLE FORMULA | Excel Worksheet Functions | |||
| Can I make formulas more flexible? | Excel Discussion (Misc queries) | |||
| flexible data range 3d-chart | Charts and Charting in Excel | |||
| Flexible Cell Reference | Excel Discussion (Misc queries) | |||
| Flexible Charts | Charts and Charting in Excel | |||
Hybrid Mode
