Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
goto a particular cell
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goto Cell With Today's Or Other Date | Excel Worksheet Functions | |||
find the last Fred and goto cell | Excel Worksheet Functions | |||
Goto a specific cell in a macro | Excel Discussion (Misc queries) | |||
Goto next empty cell in a range | Excel Programming | |||
on open goto cell with today's date | Excel Programming |