I want to select rows 3 to l_LastRow. I can't say Rows("3:l_LastRow"),
so what are my alternatives? Thanks!
This is what I have:
----------
l_LastRow = Sheet4.Cells.Find(What:=" * ", After:=[A1],
SearchDirection:=xlPrevious).Row
Sheet4.Rows("3:l_LastRow").Select
----------
--
Coolboy55
------------------------------------------------------------------------
Coolboy55's Profile:
http://www.excelforum.com/member.php...o&userid=26508
View this thread:
http://www.excelforum.com/showthread...hreadid=397766