Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
Hi I have an interesting one for you. If I have cells A1:A1000, G1:G1000 & K1:K1000 is it possible to create a named range for each of the 3000 cells i code and call them all sequentially 1-3000 Thanks if you can help. This will save me so much time! Ro -- robhargreave ----------------------------------------------------------------------- robhargreaves's Profile: http://www.excelforum.com/member.php...fo&userid=2551 View this thread: http://www.excelforum.com/showthread.php?threadid=39031 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
for each cell in Range("A1:A1000,G1:B1000,K1:K1000")
Next or Range("A1:A1000,G1:B1000,K1:K1000").Name = "Robbie" for each cell in Range("Robbie") Next -- Regards, Tom Ogilvy "robhargreaves" wrote in message news:robhargreaves.1ssjel_1122404899.6918@excelfor um-nospam.com... Hi I have an interesting one for you. If I have cells A1:A1000, G1:G1000 & K1:K1000 is it possible to create a named range for each of the 3000 cells in code and call them all sequentially 1-3000 Thanks if you can help. This will save me so much time! Rob -- robhargreaves ------------------------------------------------------------------------ robhargreaves's Profile: http://www.excelforum.com/member.php...o&userid=25519 View this thread: http://www.excelforum.com/showthread...hreadid=390315 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with named ranges | Excel Programming | |||
help with named ranges please | Excel Programming | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
named ranges - changing ranges with month selected | Excel Programming |