L
LilacSpokane
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
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