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
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
Works fine for me
You don't try to do this in a Function, do you?
It should work in a Sub
--
Kind regards,
Niek Otten
"cantonarv" <[email protected]> wrote in message
news:[email protected]...
> 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
>
see other post
--
Don Guillett
SalesAid Software
[email protected]
"cantonarv" <[email protected]> wrote in message
news:[email protected]...
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks