xlFillMonths 7 Extends the names of the months in the source range into the target
range
xlFillSeries 2 Extends the values in the source range into the target range as a
series (e.g., ???1, 2??? will be extended as ???3, 4, 5???)
xlFillValues 4 Copies only the values from the source range to the target range
xlFillWeekdays 6 Extends the names of the days of the workweek in the source range
into the target range
xlFillYears 8 Extends the years in the source range into the target range
xlGrowthTrend 10 Extends the numeric values from the source range into the target
range; assumes that each number is a result of multiplying the previous
number by some value (e.g., ???1, 2??? will be extended as ???4, 8, 16???)
xlLinearTrend 9 Extends the numeric values from the source range into the target
range, assuming that each number is a result of adding some value
to the previous number (e.g., ???1, 2??? will be extended as ???3, 4, 5???)
The copy-and-paste method is very straightforward:
1. Select the range to be copied: Range("E2").Select.
2. Choose the copy command: Selection.Copy.
3. Select the destination range: Range("E3:E4").Select.
4. Choose the Paste command: ActiveSheet.Paste.
Another interesting line of code is: ActiveCell.FormulaR1C1 = "=SUM(R[-4]C:R[-1]C)".
The default cell or range reference behavior in the Macro Recorder is to use R1C1 notation.
This provides you with row and column offsets from the active cell. It can be useful in situations
where you must calculate cell addresses to be used in your formulas.
Pages:
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45