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

should be ok. check the value of lastUsedRow



-----Original Message-----
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


.

the value is 241 but it still doesn't work - any other ideas?

"Patrick Molloy" wrote in message
...
should be ok. check the value of lastUsedRow



-----Original Message-----
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


.

I have just read that some times the Range class doesn't work when the cell
we are trying to activate is empty.
In my case this is true - how can I get round this?
"Newbie" wrote in message
...
the value is 241 but it still doesn't work - any other ideas?

"Patrick Molloy" wrote in message
...
should be ok. check the value of lastUsedRow



-----Original Message-----
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


.

Try this code (assumes column A can be used to find the last used row)

cells(rows.count,1).End(xlup).offset(1,5).Select

Make sure you don't have the sheet protected.

--
Regards,
Tom Ogilvy

"Newbie" wrote in message
...
I have just read that some times the Range class doesn't work when the
cell
we are trying to activate is empty.
In my case this is true - how can I get round this?
"Newbie" wrote in message
...
the value is 241 but it still doesn't work - any other ideas?

"Patrick Molloy" wrote in message
...
should be ok. check the value of lastUsedRow



-----Original Message-----
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


.

Try

range("F" & lastusedrow).select


Hilsen Erlen

--
Message posted from http://www.ExcelForum.com