The following will select the entire row, change the value xr to the row
required, by this method as you pass new values in xr the sheet shows a
horizontal scroll bar highlighting the row.....

Rows(xr).EntireRow.Select

You can also do it for columns by using ....

Columns(xc).EntireColumn.Select



--
Cheers
Nigel



"rahul25" wrote in
message ...

I need to scroll worksheet while using my data entry userform. How Can I
do that? Please help me.


--
rahul25
------------------------------------------------------------------------
rahul25's Profile:
http://www.excelforum.com/member.php...o&userid=28899
View this thread: http://www.excelforum.com/showthread...hreadid=486468