View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Ed[_14_] Ed[_14_] is offline
external usenet poster
 
Posts: 7
Default Selecting Rows by Column Value

The selceted rows will be made to into a .csv file.



"Alan Beban" wrote in message
...
What is supposed to happen after the rows are selected?

Alan Beban

Ed wrote:
My column "D" has only two values in it, (VALUE1 and VALUE2). My sheet

is
sorted by this column. What I want need my macro to do is only select

the
rows that have VALUE1 in column "D". Each time I run this the file size
would be different, so the first time my selection might be rows 1

through
1855. The next time it might be rows 1200 through 3500. The selection

will
always be grouped together because of the sort.


T.I.A.
Ed