View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GJR3599 GJR3599 is offline
external usenet poster
 
Posts: 4
Default finding last line in macro

How do I code a macro (or keystroke it) to find the last row that has data in
a column without harcoding the macro to a specific row? I have sections of
data (every 6th row is blank) and I want to be able to find the absolute last
row that has data in it for column B no matter where that last row is. Thanx.