Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to mark the range in VB and get application error- WHY
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to set the Display Alerts property of the application class | Excel Programming | |||
Hiding Rows Error - "Runtime Error 1004 - Unable to set the hidden property of the range class" | Excel Programming | |||
Unable to set the NumberFormat Property of the Range Class - ERROR | Excel Programming | |||
unable to close macro using auto_close or application.quit | Excel Programming | |||
unable to set formulaarray of range class ERROR when using Conditional Sum | Excel Programming |