LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Excel 2000 -Range

If the Range is $E$10: $E$20 and named Fred how does one select the
Range omitting the first cell in the range. If that can be done how
does one omit the first and last cell in the range.

The reason for asking is that I am trying to avoid breaking the macro
when it is necessary to insert or delete rows. I wish to insert
information in the cells excluding the first and last.

TIA


--

~~~~

Gerry

~~~~~~~~
Enquire, plan and execute.
Stourport, England
~~~~~~~~~~~~~~~~~

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
conditional format range set-up in Excel 2000 Ellie Excel Worksheet Functions 5 October 25th 06 09:28 AM
allow users to edit a range in excel 2000 jimar Excel Discussion (Misc queries) 6 August 24th 05 08:12 PM
Excel 2000 VBA - Set Print Range in dynamic range sub_pop[_5_] Excel Programming 2 July 27th 04 08:01 PM
Excel 2000 VBA - Selecting populated range sub_pop[_4_] Excel Programming 1 July 27th 04 05:37 PM
SOS:Know Deleted/Inserted Range in Excel 97/2000 Von Shean Excel Programming 1 December 24th 03 07:46 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"