formula to populate while skipping blank fields

Play with SpecialCells.

This code will select all rows with constant values in column A

Dim rng As Range
Set rng = Range("A1:A100").SpecialCells(xlCellTypeConstants)
rng.EntireRow.Select


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chris Hudd" <Chris [email protected]> wrote in message
news:[email protected]...
> I would use a function which will take data from a worksheet which
contains
> some rows with blank fields, and populate a worksheet with the data in a
> continuous list (without including the blank rows). I am relatively new
at
> Excel, so I need a simple explanation (i.e. I don't know how to write
> macros). Any help would be greatly appreciated.

Play with SpecialCells.

This code will select all rows with constant values in column A

Dim rng As Range
Set rng = Range("A1:A100").SpecialCells(xlCellTypeConstants)
rng.EntireRow.Select


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chris Hudd" <Chris [email protected]> wrote in message
news:[email protected]...
> I would use a function which will take data from a worksheet which
contains
> some rows with blank fields, and populate a worksheet with the data in a
> continuous list (without including the blank rows). I am relatively new
at
> Excel, so I need a simple explanation (i.e. I don't know how to write
> macros). Any help would be greatly appreciated.

Play with SpecialCells.

This code will select all rows with constant values in column A

Dim rng As Range
Set rng = Range("A1:A100").SpecialCells(xlCellTypeConstants)
rng.EntireRow.Select


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chris Hudd" <Chris [email protected]> wrote in message
news:[email protected]...
> I would use a function which will take data from a worksheet which
contains
> some rows with blank fields, and populate a worksheet with the data in a
> continuous list (without including the blank rows). I am relatively new
at
> Excel, so I need a simple explanation (i.e. I don't know how to write
> macros). Any help would be greatly appreciated.

I would use a function which will take data from a worksheet which contains
some rows with blank fields, and populate a worksheet with the data in a
continuous list (without including the blank rows). I am relatively new at
Excel, so I need a simple explanation (i.e. I don't know how to write
macros). Any help would be greatly appreciated.

Play with SpecialCells.

This code will select all rows with constant values in column A

Dim rng As Range
Set rng = Range("A1:A100").SpecialCells(xlCellTypeConstants)
rng.EntireRow.Select


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chris Hudd" <Chris [email protected]> wrote in message
news:[email protected]...
> I would use a function which will take data from a worksheet which
contains
> some rows with blank fields, and populate a worksheet with the data in a
> continuous list (without including the blank rows). I am relatively new
at
> Excel, so I need a simple explanation (i.e. I don't know how to write
> macros). Any help would be greatly appreciated.