Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill Macro
Excel 2000
What is the complete set of Excel Constants of the type: xlFill.... I'm trying to write some AutoFill macros, so that I can query the number of rows with an InputBox and then execute. I've been able to do that. I started with a recorded macro to obtain the syntax and got the following for a simple operation. Selection.AutoFill Destination:=Range("A1:A26"), Type:=xlFillDefault ****** I need to know all of the options for Type:=xlFill..... By holding down the Control Key, and starting with either an integer or a date in the base cell, and recording a macro, I find the following additional options: xlFillSeries xlFillCopy However, I can't get the autocomplete feature of Excel's VBA editor to provide a list of options for the Type:= property, nor can I find these constants, xlFill.... in the Excel VBA help index. Do additional options exist? xlFillDefault does different things depending upon the type of data in the base cell. Is there a constant that says do the default process, depending on the data in the base cell, for when the Ctrl key is pressed? (ie., if the data is a number, do a series, if the data is a date, do a copy) Many thanks, Fred Holmes |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFill Macro
hi
copied from vb help.... XlAutoFillType can be one of these XlAutoFillType constants. xlFillDays xlFillFormats xlFillSeries xlFillWeekdays xlGrowthTrend xlFillCopy xlFillDefault default xlFillMonths xlFillValues xlFillYears xlLinearTrend regards FSt1 "Fred Holmes" wrote: Excel 2000 What is the complete set of Excel Constants of the type: xlFill.... I'm trying to write some AutoFill macros, so that I can query the number of rows with an InputBox and then execute. I've been able to do that. I started with a recorded macro to obtain the syntax and got the following for a simple operation. Selection.AutoFill Destination:=Range("A1:A26"), Type:=xlFillDefault ****** I need to know all of the options for Type:=xlFill..... By holding down the Control Key, and starting with either an integer or a date in the base cell, and recording a macro, I find the following additional options: xlFillSeries xlFillCopy However, I can't get the autocomplete feature of Excel's VBA editor to provide a list of options for the Type:= property, nor can I find these constants, xlFill.... in the Excel VBA help index. Do additional options exist? xlFillDefault does different things depending upon the type of data in the base cell. Is there a constant that says do the default process, depending on the data in the base cell, for when the Ctrl key is pressed? (ie., if the data is a number, do a series, if the data is a date, do a copy) Many thanks, Fred Holmes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFill using a macro | Excel Programming | |||
Autofill Macro. | Excel Programming | |||
Autofill macro help!! | Excel Programming | |||
Autofill Macro | Excel Programming | |||
Macro to Autofill until there's a new value | Excel Programming |