Home |
Search |
Today's Posts |
#14
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It took me a good 30 seconds studying to notice the difference there :)
Thanks for the explanation of what was going on. So there is a way of bundling several ranges at ocne - thanks, that'll help a lot. Darren On Mon, 9 May 2005 16:18:42 +0100, Peter T <peter_t@discussions wrote: Typo: ActiveSheet.Names.Add "MyName", Union(Range(sAddr1), Range(sAddr1)) should read ActiveSheet.Names.Add "MyName", Union(Range(sAddr1), Range(sAddr2)) Peter T |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change format for an individual word in a cell | Excel Discussion (Misc queries) | |||
Format individual coloumn cell with corresponding coloum cell resu | Excel Worksheet Functions | |||
Format row color based on individual cell | Excel Discussion (Misc queries) | |||
hiding individual characters in Excel | Excel Discussion (Misc queries) | |||
Can Excel access substrings and individual characters? | Excel Discussion (Misc queries) |