How do I copy (values) a range of cells that have blank rows in
between to another range without the blank rows. I thought it was copy-
paste special values-skip blanks, but when I do I still see the blank
rows

eg Copy values in A1:A5 (blank rows are in A2 & A4) to M1:M3

Thanks

"Sean" <(E-Mail Removed)> wrote:

> eg Copy values in A1:A5 (blank rows are in A2 & A4) to M1:M3

Just in case that you're talking about Excel, repost (via Newsreader) to
the appropriate group.
news://msnews.microsoft.com/microsoft.public.excel.misc

--
d-d

On Jun 27, 9:30 am, "Detlev Dreyer" <detdre...@flashmail.com> wrote:
> "Sean" <seanrya...@yahoo.co.uk> wrote:
> > eg Copy values in A1:A5 (blank rows are in A2 & A4) to M1:M3
>
> Just in case that you're talking about Excel, repost (via Newsreader) to
> the appropriate group.
> news://msnews.microsoft.com/microsoft.public.excel.misc
>
> --
> d-d

Sorry I just noticed, selected wrong Group from my favourites, and I
was wondering why a VPN post had appeared on an Excel Board Dooooh

"Sean" <(E-Mail Removed)> wrote:

> Sorry I just noticed, selected wrong Group from my favourites, and I
> was wondering why a VPN post had appeared on an Excel Board Dooooh

LOL!

--
d-d