Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '424': Object Required
I keep getting the error in the subject line. Can someone please help.
Thank you. Sub CopyFixedAssetsformulas() Dim startRange As Range Dim rglast As Variant Dim lastrange As Variant Set startRange = Sheet20.Range("A5") Set rglast = Sheet20.Range("A5").SpecialCells(xlCellTypeLastCel l) Set lastrange = Sheet20.Range("A5", "A" & rglast.Row).Find("Summary", LookIn:=xlValues) Sheet20.Range("K5", "V5").Copy Sheet20.Range("K6", "V" & lastrange.Row - 2).PasteSpecial (xlPasteFormulasAndNumberFormats) Application.CutCopyMode = False Sheet20.Range("A5").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime error '424': Object Required | Excel Discussion (Misc queries) | |||
Run time error '424' object required | Excel Programming | |||
Excel 2007 Beta 2 - Macro Run-time error '424' Object required | Excel Programming | |||
Run-time error '424': Object required | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |