| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
With End using multiple ranges
Is it possibe to use With End stmts on muliple ranges. Below I am adjsuting
the properties of one range. If I want to do this to two separate ranges, can I append the With part of the statement to also take the second range ("SecondCell"). Thanks With Range("FirstCell") .Interior.Pattern = xlGray50 .Locked = True .FormulaHidden = False .Validation.InCellDropdown = False End With |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
With End using multiple ranges
Try
With Range("FirstCell, SecondCell") 'do something here End With -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "ExcelMonkey" wrote in message ... Is it possibe to use With End stmts on muliple ranges. Below I am adjsuting the properties of one range. If I want to do this to two separate ranges, can I append the With part of the statement to also take the second range ("SecondCell"). Thanks With Range("FirstCell") .Interior.Pattern = xlGray50 .Locked = True .FormulaHidden = False .Validation.InCellDropdown = False End With |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
With End using multiple ranges
Perfect, thanks.
"Nick Hodge" wrote: Try With Range("FirstCell, SecondCell") 'do something here End With -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "ExcelMonkey" wrote in message ... Is it possibe to use With End stmts on muliple ranges. Below I am adjsuting the properties of one range. If I want to do this to two separate ranges, can I append the With part of the statement to also take the second range ("SecondCell"). Thanks With Range("FirstCell") .Interior.Pattern = xlGray50 .Locked = True .FormulaHidden = False .Validation.InCellDropdown = False End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create Multiple passwords to edit multiple ranges? | Excel Discussion (Misc queries) | |||
| How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
| Crteating Multiple GIFS from Multiple Ranges -- need someone to test my code to see why it fails | Excel Programming | |||
| Crteating Multiple GIFS from Multiple Ranges -- need someone to test my code to see why it fails | Excel Programming | |||
| Printing Multiple Ranges from Multiple Worksheets | Excel Programming | |||
Hybrid Mode
