Thread
:
Unable to mark the range in VB and get application error- WHY
View Single Post
#
4
Posted to microsoft.public.excel.programming
Sandy Mann
external usenet poster
Posts: 2,345
Unable to mark the range in VB and get application error- WHY
There is no such cell as Cell(0,0), try using Cell(1,1)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"CAPTGNVR" wrote in message
...
DEAR ALL
Active cell is A5. I need to select the range from 5th row to the last
populated cell which is obtained from xldown.row to 5 columns to the
right.
Public Sub LASTTROW()
LASTROW = ActiveCell.End(xlDown).Row
ActiveCell.Range(Cells(0, 0), Cells(LASTROW, 5)).Select
End Sub
What is wrong in this code to get run time error 1004-
'application-defined
or object defined error'.
or sugest
VB
to mark from the active cell to last populated row and 5
columns to the right.
pls help-captgnvr
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann