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
: Thursday, March 08, 2012 11:58 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Remove empty cells without deleting row
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
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. I cannot delete rows as I have other data on the
worksheet. I need to do this in VBA.
