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
its work
thank you sir,
nandkumar
On Mon, Apr 4, 2011 at 9:01 AM, STDEV(i) wrote:
> The 'real' deleting rows
>
> Sub RemoveBlankRows()
>' by STDEV(i) & siti Vi
>'--
>Dim r As Long, Rng As Range
>Set Rng = ActiveSheet.UsedRange
>Application.Calculation = x
"remove" blank ROWS
1. type 202 in cell A145
2. select range A3:K145
3. in the Standar Toolbar > click Icon Sort Ascending
Change figures to positif numbers
use function ABS function
for example in cell N3 put this formula
=ABS(F3)
you can copy N3 and PasteSpecial > Value to F3 again
On S
