View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default 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