Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update...."object required" rt er 424
ok I replaced the bold statement with ... SET ACTIVESHEET.RANGE(RRANGE2) = RRANGE1.AUTOFILL(RRANGE2, XLFILLFORMATS AND XLFILLSERIES) it completes the fill with the correct series ...but I am getting a run time error 424.... object required? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
update...."object required" rt er 424
sorry this belongs to my previous post...I apologiz ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
update...."object required" rt er 424
finally figured it out using the "record a macro" feature....very handy. working code... Sub CashFlow() Dim rRange1 As Range Dim rRange2 As Range Dim strDate1 As String Dim strDate2 As String Set rRange1 = Application.InputBox("2 cells", , , , , , , 8) Set rRange2 = Application.InputBox("total range", , , , , , , 8) strDate1 = Application.InputBox("1st date", , , , , , , 2) strDate2 = Application.InputBox("pattern date", , , , , , , 2) [rRange1] = Array(strDate1, strDate2) rRange1.Select Selection.AutoFill Destination:=rRange2, Type:=xlFillDefault rRange2.Select End Sub ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do i "sometimes" need to "edit chart object" before "source da | Charts and Charting in Excel | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
error while compiling "OBJECT REQUIRED" | Excel Discussion (Misc queries) |