View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gmangad[_6_] gmangad[_6_] is offline
external usenet poster
 
Posts: 1
Default Need help to find the last row of data

Hello
I need someone to help me to write a macro to find the last row in my
data.
I will have two columns A & B with text in it.
Suppose I have data in 5 row, 6th row will be empty. When I run the
macro I want the data to be selected A1:B5. If I enter another item in
my data and run the macro, it should select A1:B6. That is the first
step, then I want the data to be sorted on Column A. I hope this is
clear . I am desperately looking someone to help me.
Thanking you
GT


---
Message posted from http://www.ExcelForum.com/