Posted to microsoft.public.excel.programming

Soniya[_2_] Soniya[_2_] is offline

external usenet poster

Posts: 15

Select current region less one column

Hi all,

I have data in my sheet1 in column F thru F (starting
from row 3, row 2 being column heading.

I want to print various reports based on aurofilter
crieteria of column A. since my column A item have been
added to page header i want to print the selection
starting from column B thru F

How can do useing macro?

TIA
Soniya

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
Current region emulation	daverau	Excel Worksheet Functions	5	October 16th 09 04:31 AM
Sort doesn't recognize current region	RobWN	Excel Worksheet Functions	2	September 7th 07 10:48 PM
Copy Current Region	Rohit Thomas[_2_]	Excel Programming	1	December 4th 03 01:55 AM
Naming Current Region	Gavin[_4_]	Excel Programming	3	October 14th 03 03:38 PM

All times are GMT +1. The time now is 10:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us