Posted to microsoft.public.excel.programming

John[_140_] John[_140_] is offline

external usenet poster

Posts: 57

Select current region less 2 rows at the top

I would like to select my current region, less 2 rows at the top. My current
region is A1 to S?, I would like vba to select A3 to S?. I'm thinking maybe
a rezsize or an offset but I can't figure out the code. Thank you.

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
Select the current region excluding the top row	DZ	Excel Programming	1	June 26th 08 03:32 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
Selecting a range composed of current region + 2 rows	Bruce Roberson[_5_]	Excel Programming	2	October 27th 04 03:00 PM
Select current region less one column	Soniya[_2_]	Excel Programming	1	January 12th 04 02:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us