Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Differences
Is there a Method opposite of ColumnDifferences? I looking to select all the
cells within a column that are the same. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Differences
Hi DD
Is there a Method opposite of ColumnDifferences No, Use a AutoFilter for that -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... Is there a Method opposite of ColumnDifferences? I looking to select all the cells within a column that are the same. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Differences
After I autofilter how do I select the filtered rows?
Selection.AutoFilter Selection.AutoFilter Field:=2, Criteria1:=B2 "Ron de Bruin" wrote: Hi DD Is there a Method opposite of ColumnDifferences No, Use a AutoFilter for that -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... Is there a Method opposite of ColumnDifferences? I looking to select all the cells within a column that are the same. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Differences
Selecting is not needed in 99% of the cases
What do you want to do ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... After I autofilter how do I select the filtered rows? Selection.AutoFilter Selection.AutoFilter Field:=2, Criteria1:=B2 "Ron de Bruin" wrote: Hi DD Is there a Method opposite of ColumnDifferences No, Use a AutoFilter for that -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... Is there a Method opposite of ColumnDifferences? I looking to select all the cells within a column that are the same. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Differences
I have a about 250 rows. I want to select and grab the rows that all have the
same value in column B and copy and paste them into their own spread sheet for each change in column B. "Ron de Bruin" wrote: Selecting is not needed in 99% of the cases What do you want to do ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... After I autofilter how do I select the filtered rows? Selection.AutoFilter Selection.AutoFilter Field:=2, Criteria1:=B2 "Ron de Bruin" wrote: Hi DD Is there a Method opposite of ColumnDifferences No, Use a AutoFilter for that -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... Is there a Method opposite of ColumnDifferences? I looking to select all the cells within a column that are the same. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Differences
See this page then DD
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... I have a about 250 rows. I want to select and grab the rows that all have the same value in column B and copy and paste them into their own spread sheet for each change in column B. "Ron de Bruin" wrote: Selecting is not needed in 99% of the cases What do you want to do ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... After I autofilter how do I select the filtered rows? Selection.AutoFilter Selection.AutoFilter Field:=2, Criteria1:=B2 "Ron de Bruin" wrote: Hi DD Is there a Method opposite of ColumnDifferences No, Use a AutoFilter for that -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... Is there a Method opposite of ColumnDifferences? I looking to select all the cells within a column that are the same. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Differences
Thanks Ron:)
"Ron de Bruin" wrote: See this page then DD http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... I have a about 250 rows. I want to select and grab the rows that all have the same value in column B and copy and paste them into their own spread sheet for each change in column B. "Ron de Bruin" wrote: Selecting is not needed in 99% of the cases What do you want to do ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... After I autofilter how do I select the filtered rows? Selection.AutoFilter Selection.AutoFilter Field:=2, Criteria1:=B2 "Ron de Bruin" wrote: Hi DD Is there a Method opposite of ColumnDifferences No, Use a AutoFilter for that -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DD" wrote in message ... Is there a Method opposite of ColumnDifferences? I looking to select all the cells within a column that are the same. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlight differences | Excel Worksheet Functions | |||
differences between 3 | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions | |||
time differences in a column | Excel Worksheet Functions | |||
Column heading differences | Excel Discussion (Misc queries) |