| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a macro to copy into a series of variable ranges
I have formulas that i need to copy to fill the end of each of a set of data
ranges. The data is all in A1 to A500, with the ranges seperated by empty rows. The ranges are of variable length. The formula is required in the A column just where the blanks appear in the ranges. Why can't I record a relative address macro that incorporates variable ranges? I use the end-down-down keys when recording the macro. Do I have to use a VBA script for something this simple? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to COPY FORMULA BETWEEN RANGES | Excel Discussion (Misc queries) | |||
| Macro to Copy Var. Ranges to Var. Rows | Excel Discussion (Misc queries) | |||
| Using macro/vba to copy varying ranges of rows | Excel Discussion (Misc queries) | |||
| Counting variable ranges and auto-summing variable ranges | Excel Programming | |||
| Copy variable ranges fron difernte shets | Excel Worksheet Functions | |||
Threaded Mode
