View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Newbie Newbie is offline
external usenet poster
 
Posts: 40
Default goto a particular cell

Hi

I have a variable that holds the row no. I want to make "F"lastused row the
active cell. How can I do this? I have tried:

cells(lastUsedRow,"F").select
but get the error 1004 Select method of Range class failed

and then I tried:

Cells(lastUsedRow, 6).Activate
but get the error 1004 Activate method of Range class failed

Here is the code I have what am I doing wrong?
lastUsedRow = ActiveSheet.UsedRange.Row +
ActiveSheet.UsedRange.Rows.Count -1
Cells(lastUsedRow, 6).Activate