Newbie wrote:
Hi,
I use the following to get the last row number used

lastUsedRow = Worksheets("Sheet1").UsedRange.Row +
Worksheets("Sheet1").UsedRange.Rows.Count - 1

How can I use the lastUsedRow variable so that I can make column F
and the lastUsedRow varialbe the active cell.

eg. lastUsedRow = 241 therefore I want F241 to become the active cell

Cells(lastUsedRow, 6).Activate

--
Regards,

Juan Pablo González