View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LilacSpokane LilacSpokane is offline
external usenet poster
 
Posts: 4
Default How do I goto column B in the current row using VBA?

I need to enter the text "The End" at the end of the worksheet in column B.
I am using ActiveCell.SpecialCells(xlLastCell).Select to find the last cell
in the worksheet. Currently that is cell F379, on my next report the column
may change. Whatever column the last cell turns out to be, I need to enter
"The End" in the last row of Column B. Is there VBA code to goto column B in
the current row?
Thank you
L