sorting data

[marcus.brown]

hi,

I have a stream of data and I need to sort the rows in alphabetical order (A-Z), with the sortfield being in column A. However, i don't know the size of the data (it will vary day to day).

How can i go about sorting the rows, when I don't know the size of my data? All i know is that the data will begin from row 3 and there won't be any blank rows, until the last data. After a gap, there may be some other data, which needs to remain as is.

I'm not sure if i've been very clear - apologies if not.

Thanks,
Aftab

 

[Greg Truby]

Unless I'm missing something, just click the sort button? Excel will pick up the data block if it as you describe - no blank rows (or columns if the data block is multi-columnar); and the non-sortable data is below a blank row. Note that if your data contains naught but text (no numbers or dates) then you might need to use the Sort dialog to tell Excel that your data has headers (assuming it does, indeed have headers).

 

[marcus.brown]

sorry, i don't think i was very clear - i need it in vba, and just clicking on sort, picks up rows below the data, which i don't want it to pick up.

i want it to sort the data from row 3 until the first non-empty cell in column A.

 

[Greg Truby]

What code have you written thus far?