Posted to microsoft.public.excel.programming

Stevens

external usenet poster

Posts: 19

ActiveWindow.VisibleRange.Width - Is this the correct code

Is this the correct code to size a cell to the size of a users screen no
matter what the size
'eg
Columns("p:p").ColumnWidth = ActiveWindow.VisibleRange.Width / 8 (8 = factor
to convert to pixels)
--
SS

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
print out is not correct,page width differrant	ISSUE IN MS OFFICE	Excel Discussion (Misc queries)	0	August 24th 09 07:32 AM
Code is not correct	Pat	Excel Programming	10	April 6th 05 02:03 AM
Help to correct code	Pat	Excel Programming	6	December 29th 04 05:02 PM
ActiveWindow.Width no longer works for me!	rickety	Excel Programming	2	September 1st 04 01:29 AM
ActiveWindow.Width no longer works for me!	rickety[_2_]	Excel Programming	0	September 1st 04 01:25 AM

All times are GMT +1. The time now is 07:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us