Posted to microsoft.public.excel.programming

Nick Smith[_2_] Nick Smith[_2_] is offline

external usenet poster

Posts: 43

setting print area

Hi,

Can anyone help me with a macro to search down column A from row 15 onwards
(inclusive) until it finds the last cell containing any text (cell #), and
then set the print area to cells A1:X#, where # is the last cell in column A
containing any text?

Any help with this would be much appreciated!

Thanks in advance,

Nick

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 Area Setting	RozBuds	Excel Discussion (Misc queries)	3	February 19th 10 09:41 PM
Setting The Print-Area ?	Robert11[_3_]	New Users to Excel	2	May 31st 09 03:24 PM
Setting the print area	Patch61	Excel Programming	5	April 18th 06 04:42 PM
Setting The Print Area	beans_21	Excel Programming	3	January 10th 06 09:32 AM
setting a print area	Matilda	Excel Programming	2	November 13th 05 07:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us