Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
Object Required | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) |