| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set range
make sure that you have
OPTION EXPLICIT at the top of your module then DIM MyRangeOne as Range DIM MyRangeTwo as Range SET MyRangeOne = Worksheets("sheet2").Range("Z12:AG12") SET MyRangeTwo = Worksheets("sheet2").Range("Z13:AG500") "Excel User" wrote in message ... Hi, I keep getting an error with the following: MyRangeOne = Worksheets("sheet2").Range("Z12:AG12") MyRangeTwo = Worksheets("sheet2").Range("Z13:AG500") Is this not the way to set a range? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
set range
Patrick,
Thanks for your reply, I'm picking up someone's script, it seems that MyRangeOne & MyRangeTwo are set as DIM MyRangeOne as String. Thanks! "Patrick Molloy" wrote in message ... make sure that you have OPTION EXPLICIT at the top of your module then DIM MyRangeOne as Range DIM MyRangeTwo as Range SET MyRangeOne = Worksheets("sheet2").Range("Z12:AG12") SET MyRangeTwo = Worksheets("sheet2").Range("Z13:AG500") "Excel User" wrote in message ... Hi, I keep getting an error with the following: MyRangeOne = Worksheets("sheet2").Range("Z12:AG12") MyRangeTwo = Worksheets("sheet2").Range("Z13:AG500") Is this not the way to set a range? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
| Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
| how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming | |||
Hybrid Mode
