| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy named range & paste values
This works great with columns, but now need to copy named range ActiveCell.EntireColumn.Value = ActiveCell.EntireColumn.Value (my attempt) Sub select_range() Range("zero_range").Select Copy.Range Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy named range & paste values
Range("zero_range").value=Range("zero_range").valu e
-- Don Guillett Microsoft MVP Excel SalesAid Software "J.W. Aldridge" wrote in message ... This works great with columns, but now need to copy named range ActiveCell.EntireColumn.Value = ActiveCell.EntireColumn.Value (my attempt) Sub select_range() Range("zero_range").Select Copy.Range Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy named range & paste values
thanx!!!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy named range & paste | Excel Programming | |||
| Copy & Paste Named Range Contents | Excel Programming | |||
| After Copy and Paste, Add to an Existing Named Range | Excel Programming | |||
| Copy and Paste 2 columns from a named range? | Excel Programming | |||
Linear Mode
