Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting with Dynamic Last Row
I'm trying to paste a formula with a dynamic range, it could be 2000 rows to
10000 rows (see below). I tried defining LastRow using a Function but it won't work. Anyone have a better way? The brute force alternative is to set a large range, which works, but is messy because I want to then sort in a way that leaves me with up to thousands of empty cells in the wrong place. ActiveCell.Offset(1, 0).Range("A1").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select ActiveCell.Range("A1:A(LastRow)").Select ActiveSheet.Paste Thanks for any ideas. Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
Dynamic copying & pasting of rows | Excel Programming | |||
Selecting & Pasting Dynamic Ranges | Excel Programming |