Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code which errors on the resize line
Cells.Find(what:="Pending", after:=ActiveCell, LookIn:=xlFormulas, lookat:= _ xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate ActiveCell.Resize(0, 1).Select Selection.EntireColumn.Cut ActiveCell.Offset(0, 1).Select Selection.Insert Shift:=xlToRight What the desired result is, look for cell with "Pending", select that cell and the one to the right, cut both those columns and move them one to the right. TIA Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I could NOT resize the axis title but excel allows me to resize gr | Charts and Charting in Excel | |||
Problem transferring array data onto worksheet using Resize | Excel Programming | |||
having problem with resize | Excel Programming | |||
problem with resize property | Excel Programming | |||
Resize Range Problem | Excel Programming |