Thread: Macro help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Confusicous Confusicous is offline
external usenet poster
 
Posts: 23
Default Macro help

Sub Macro1()
'
' Macro1 Macro
'

'
Range("P4:Q7").Select
Selection.Cut
Range("A14").Select
ActiveSheet.Paste
Range("R4:S7").Select
Selection.Cut
Range("A18").Select
ActiveSheet.Paste
End Sub

Here is a macro I am working on and I need it to continue for 98 more times
but I can't figure out the loop. Any help is appreciated. Thanks