Pace and Cap - Sartin Methodology & The Match Up - View Single Post

TheProgrammer · 05-02-2008, 11:49 PM

Just select the sheet you want to change first (example):

Worksheets("BOX").Select
Range("B3:HZ14").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft

Worksheets("OUT").Select
Range("B3:HZ14").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft

RK

05-02-2008, 11:49 PM	#2
TheProgrammer AlwNW3X Join Date: Apr 2008 Posts: 37	Just select the sheet you want to change first (example): Worksheets("BOX").Select Range("B3:HZ14").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft Worksheets("OUT").Select Range("B3:HZ14").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft RK __________________ If living life were easy, everyone would be doing it. - anon