Hi forum

I was record a macro that going to the last row with data + 1.In th
first row I press on "end" key and after "down arrow" key and one mor
press on "down
arrow" key to arrived to first row without data.
for example :
Range("I1").Select
Selection.End(xlDown).Select
Range("I6").Select

The problem that Excel define "hard" range "I6" and I want that it wil
work even there is more then 6 row

Thanks in advance

yochai
:confused

--
yocha
-----------------------------------------------------------------------
yochai's Profile: http://www.excelforum.com/member.php...fo&userid=2576
View this thread: http://www.excelforum.com/showthread.php?threadid=39177