Thread: Make a particular cell the active one
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Newbie Newbie is offline
external usenet poster
  
Posts: 40
Default Make a particular cell the active one
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



Reply With QuoteReply With Quote