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
.
|