|
Column Differences
Is there a Method opposite of ColumnDifferences? I looking to select all the
cells within a column that are the same. |
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. |
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com