| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Locating variable range to copy
I am an ordinary accountant but not familiar with macro & VBA. I have a file, I need to copy a source formula to a certain range of which starting position has fixed already and ending position would be altered regarding to condition changed.
For example, say source formula : locating at cell G11 conditions : range of row containing data in column F starting from F11 Says now, there are 10 data starting from F11 to F20, therefore I need to copy the source formula from G11 to G20. Same as, when there are 100 data starting from F11 to F110, I need to copy the source formula from G11 to G110. Can someone advise me how to specify the range in performing a macro in Excel v2002. Thank you very much. Eric C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
| How do you copy RANK w/o it changing the range? | Excel Worksheet Functions | |||
| Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) | |||
| Is it possible to set a variable range in a macro? | About this forum | |||
| Set Data Range by Variable | Excel Discussion (Misc queries) | |||
Threaded Mode
