Selection.End(xlDown).Select
'Range("A4").Select
'Selection.End(xlDown).Select
The following 2 lines starts from cell “A4” and selects to last data line. But if there is only one data line the spreadsheet the Selection.End(xlDown).Select goes right till end of spreadsheet. It select all 65000 lines.
Only one line has data against it and rest are blank lines..Should only select one line
Does anyone have any suggestions pls
Thanks
Zahed
You might want to use code tags next time you post?!If Not Range("A5").Value = "" Then Range(Range("A4"), Range("A4").End(xlDown)).Select Else: Range("A4").Select End If
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks