Posted to microsoft.public.excel.programming

external usenet poster

Posts: 29

Select the current region excluding the top row

Hi

I want to select the current region excluding the top row
The following did not work

Selection.CurrentRegion.Resize(-1, 0).Select

Can someone help me ?

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
looping through current region	buffyslay	Excel Programming	2	February 1st 06 05:58 PM
Select current region and print	Tempy	Excel Programming	2	April 20th 05 05:47 AM
Select current region less one column	Soniya[_2_]	Excel Programming	1	January 12th 04 02:05 PM
Copy Current Region	Rohit Thomas[_2_]	Excel Programming	1	December 4th 03 01:55 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us