View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Goodmen Dean Goodmen is offline
external usenet poster
 
Posts: 18
Default Dealing with Ranges

I looked in the excel help files but could not seem to find an
examples on Ranges and adding and removing ranges
from it. I was hoping someone here could someone make up a short
example for me.

1 I need a Ranged created that I can Add and Remove cells from
within any sub in my workbook.
2 Sample line to Add and remove a cell range. (Example :
TotalRange = TotalRange - My range)
3 Sample line to check if a range is contained in the range(
Example : Is MyRange in TotalRange.)

Thanks in advance :