View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 46
Default macro Cell designation


When I run this macro:

-------------------------------------------------------

For z = 5 To 100
Range("Jz").Select
Application.CutCopyMode = False
Selection.Cut
Range("J(z-1)").Select
ActiveSheet.Paste

Next

----------------------------------------------------------------

I get message:

-----------------------------------------------------------------

Run time error '1004':

Method ' Range' of object _'Global failed"

----------------------------------------------------------------

Please tell me how to correct the code.

Thanks.

Ed