| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
row argument query...
Dear All, In my (recorded) macro there is this bit... Range("Y5:AB5").Select Selection.Copy Range("Y6").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select ActiveSheet.Paste this copies the formulae down to the last active cell and pastes them...this is fine and is the only way I could think how to do it...but i only want to paste down as far as the number of rows in the adjacent "X" column next to the Range("Y5:AB5")... The practical difference is pasting down only 200 or so rows as opposed to the 3000 rows and therefore a considerable time/file size saving... ...I have tried to look up various solutions but I am struggling... Jaime (LVP!) -- jaimetimbrell ------------------------------------------------------------------------ jaimetimbrell's Profile: http://www.excelforum.com/member.php...o&userid=26162 View this thread: http://www.excelforum.com/showthread...hreadid=508365 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If argument | Excel Worksheet Functions | |||
| IF function - If false argument query | Excel Worksheet Functions | |||
| Can I use the argument: - IF, AND, THEN, ElSE | New Users to Excel | |||
| what is an argument? | Excel Discussion (Misc queries) | |||
| Function (array argument, range argument, string argument) vba | Excel Programming | |||
![jaimetimbrell[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
