View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default Dealing with Ranges

How about removing a range of cells from a range?

There's no built-in function for that. You'll have to do it brute-force.

Also the main range will be created on an OPEN event, will the ranges
be avaible to other sub if created there?


Only if you Dim the range variable as a public module-level variable,
preferably in a standard module.