Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ignore blank rows
hi,
I have the following: Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Which basically copies the values from a pivot table. The only problem is that it is copying a row marked (blank) also. Here is the data: t1 359 145 65 30 13 15 19 t2 300 117 64 27 16 21 25 t3 191 73 30 33 12 9 15 t4 278 115 70 25 12 19 32 t5 259 123 54 29 17 17 17 (blank) Grand ttl 1,387 573 283 144 70 81 108 I want it to copy everything but the row marked (blank). How can I do this? Thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ignore blank rows
hide the row marked blank before you copy? Then do
selection.specialcells(xlVisible).copy -- Regards, Tom Ogilvy "geebee" wrote: hi, I have the following: Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Which basically copies the values from a pivot table. The only problem is that it is copying a row marked (blank) also. Here is the data: t1 359 145 65 30 13 15 19 t2 300 117 64 27 16 21 25 t3 191 73 30 33 12 9 15 t4 278 115 70 25 12 19 32 t5 259 123 54 29 17 17 17 (blank) Grand ttl 1,387 573 283 144 70 81 108 I want it to copy everything but the row marked (blank). How can I do this? Thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ignore blank | Excel Discussion (Misc queries) | |||
SUMPRODUCT - Ignore blank rows | Excel Worksheet Functions | |||
ignore blank | Excel Discussion (Misc queries) | |||
Ignore Blank Cells | Excel Programming | |||
Ignore blank rows to populate custom drop down list column range | Excel Programming |