View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stakar[_14_] stakar[_14_] is offline
external usenet poster
 
Posts: 1
Default Go to lastrow using other column's lastrow

i have the following problem
I want to use the column's G lastrow and go to the lastrow of th
worksheet("A") activecolumn using a macro

Be more specific

last_row = Worksheets("A").Range("G65536").End(xlUp).Row

Using the last_row i want to go to the last_row of the activecolumn.
So if the last_row =120 and the activecolumn is "B" i want to go to th
cell 'B120'

Thanks in advance
Stathi

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