Thread: cut&paste
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Lidström Daniel Lidström is offline
external usenet poster
 
Posts: 7
Default cut&paste

Hi!

How can I cut and paste a range of cells into another place? I'm trying
with:
Sub HidePersonal()
Range("Q35:Q40").Select
Selection.Copy
Selection.Clear
End Sub
Sub UnhidePersonal()
Range("Q35:Q40").Paste
End Sub

But this doesn't work (error 438). How can this be done?
Thanks!

--
Daniel