'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
Bookmarks