| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a calculated column value within a range
I need to use code similar to the following:
Range("H13:M13").Select Selection.AutoFill Destination:=Range("H13:M18"), Type:=xlFillDefault except that I need the end of the range (M18) to be a calculated value, eg M13 plus a variable number of rows. I suspect the solution is to write the range in row and column format, but how do I do that please? thanks ... Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using a calculated column value within a range
Hi GVM,
Try someting like: Sub Tester() Dim iRow As Long iRow = 50 Range("H13:M13").AutoFill _ Destination:=Range("H13:M" & iRow), _ Type:=xlFillDefault End Sub '=================== --- Regards, Norman "gvm" wrote in message ... I need to use code similar to the following: Range("H13:M13").Select Selection.AutoFill Destination:=Range("H13:M18"), Type:=xlFillDefault except that I need the end of the range (M18) to be a calculated value, eg M13 plus a variable number of rows. I suspect the solution is to write the range in row and column format, but how do I do that please? thanks ... Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AVERAGE cells on another worksheet when the range is calculated | Excel Discussion (Misc queries) | |||
| Indirect Hyperlink from a graphic to a calculated cell or range | Excel Worksheet Functions | |||
| how to sort a range which is calculated by array formula | Excel Discussion (Misc queries) | |||
| Display Last Value Calculated in Formula Range | Excel Worksheet Functions | |||
| Can the sum of 1p + 3p be calculated in a column in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
