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

Hi

You can use Offset

Range("I1").Select
Selection.End(xlDown).Offset(1, 0).Select


--
Regards Ron de Bruin
http://www.rondebruin.nl


"yochai" wrote in message
...

Hi forum

I was record a macro that going to the last row with data + 1.In the
first row I press on "end" key and after "down arrow" key and one more
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 will
work even there is more then 6 row

Thanks in advance

yochai



--
yochai
------------------------------------------------------------------------
yochai's Profile: http://www.excelforum.com/member.php...o&userid=25769
View this thread: http://www.excelforum.com/showthread...hreadid=391773