View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kate[_2_] Kate[_2_] is offline
external usenet poster
 
Posts: 9
Default Cells(Rows.Count, "b").End(xlUp).Row

So, you can use the formula in the subject line (Cells(Rows.Count,
"b").End(xlUp).Row) to select the last cell in the column. But, I have
a table with a variable number of rows, which will most likely be
empty.

So instead of selecting the last cell with a value in it, I want to
select hte last cell with a border around it.

How?

Thanks