How to make a selected row visible in the Window?

Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

How to make a selected row visible in the Window?

Hi,

I have a worksheet and a Userform. The userform has a commandbutton to
which the following code is attached:
Cells(Selection.Row, 11).Offset(1, 0).Select
The idea is to select the the cell in Column 11 in the next row below.
This happens successfully. However, the row having the selected cell
is not automatically visible (vertically scrolled into )in the window.
How can I get this done?

Thanks in advance for the help.

Regards,
Raj

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to avoid getting the IDE window visible?	RB Smissaert	Excel Programming	0	August 7th 07 12:01 AM
scroll window to display selected cell in visible area?	Kate	Excel Programming	5	January 3rd 06 03:38 PM
Make selected row visible to user when out of screen view	ExcelMonkey	Excel Programming	3	August 19th 05 12:43 PM
how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet.	Daniel	Excel Worksheet Functions	1	July 12th 05 01:30 AM
make hidden window or workbook visible without specify the name	mango	Excel Worksheet Functions	1	December 30th 04 03:05 PM

All times are GMT +1. The time now is 11:23 AM.

Menu

About Us