You can use Go To special function
On Fri, Mar 9, 2012 at 1:28 PM, Brian wrote:
> In column a from row 4 to row 52 I have a list of numbers. however
> some cells are empty. I need to remove the empty cells so that i
> have a list of numbers from row 4 downwards with no empty cells
> inbetween
Hi Brian,
This will shift cells in that column up after deleting just blank cells:
Range("A4:A52").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Brian
Sent: Thursday, Ma
