Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
separate names and designation from one cell into 2 colmun | Excel Discussion (Misc queries) | |||
Cell designation | Excel Programming | |||
cell designation | Excel Discussion (Misc queries) | |||
Invisible Text designation in cell? | Excel Worksheet Functions | |||
Specific Row Designation | Excel Programming |