| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selective formula pasting
Tanks Alf
alf bryn wrote: One possible solution asuming that your starts in A3 : Sub Macro1() ' Dim MyRange As Range Set MyRange = Range(Range("A3"), Cells(Rows.Count, 1).End(xlUp)) End Sub If you want to extand the range to include colums B, C, D and E as well replace Range(Range("A3"), Cells(Rows.Count, 1).End(xlUp)) with Range(Range("A3"), Cells(Rows.Count, 1).End(xlUp).Offset(0, 4)) Hi [quoted text clipped - 3 lines] range will change month on month I need to alter the cell range that the formula is pasted into. Is this possible? -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selective formula | Excel Discussion (Misc queries) | |||
| Formula to sum selective data. | Excel Discussion (Misc queries) | |||
| Pasting a formula in many different workbooks | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
| Pasting formula as text | Excel Programming | |||
Hybrid Mode
