Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple range problem
what am i doing wrong
dim myRange as Range dim iNum as integer iNum= 6 Set myRange = Cells(iNum + 2, 1) myRange.Value = 34 trying to set a cell myRange to cell(8,1) then putting the value 34 into the cell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple range problem
I just tested with xl2002 and it worked fine but why not just
cells(inum+2,1)=34 or cells(8,1)=34 -- Don Guillett SalesAid Software "cantonarv" wrote in message oups.com... what am i doing wrong dim myRange as Range dim iNum as integer iNum= 6 Set myRange = Cells(iNum + 2, 1) myRange.Value = 34 trying to set a cell myRange to cell(8,1) then putting the value 34 into the cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
Simple function problem | Excel Worksheet Functions | |||
Very simple percentage problem | New Users to Excel | |||
Problem adding a range using Sumif function. | Excel Worksheet Functions |