| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative Copy Range setting
Each period I download a block of data and index it for reporting. The Index
Vlookups reside A1 - AY1 My data block sits in AB5 - AZ100. Last period I indexed the data by copying the Index down from A5 - A50; for current period I need to copy the Index Vlookup formula range from A51 - A 100. Next period, the raw data range will expand by an unpredicatable number of rows. I need the VBA coding to indicate a relative paste range beginning at the first empty row in Col A, ending with the last row number in the data block beginning in AZ. Any help on how to configure that statement(s)? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting worksheets not maximized to relative size | Excel Programming | |||
| COPY RELATIVE FORMAT | Excel Discussion (Misc queries) | |||
| Setting a range within a loop variable for copy/paste | Excel Programming | |||
| Setting links to relative paths from ppt to xls | Links and Linking in Excel | |||
| Setting Relative Conditional Formatting via Macro | Excel Programming | |||
Linear Mode
