Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |