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 |
goto a particular cell
|
goto a particular cell
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 . |
goto a particular cell
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 . |
goto a particular cell
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 . |
goto a particular cell
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 . |
All times are GMT +1. The time now is 12:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com