View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Macro to go to the last value

to select the last occupied cell in column A:

n = Cells(Rows.Count, "A").End(xlUp).Row
Cells(n, "A").Select
--
Gary''s Student - gsnu200744


"tc" wrote:

Hi. How do i create a macro that will go to the last value in a given
column?