changing cell value in vba

[lezawang]

Hi
If I want to change a cell value then I can write this code

sub abc[INDENT]thisworkbook.activesheet.cells(1,1).value =10[/INDENT]
end sub

but I can also do that by writing this code

sub abc[INDENT]cells(1,1).value =10[/INDENT]
end sub

I see both give the same result. I do not see any advantage of one on another except the second one is easier to type. Which one is the right one? is there any cases I can only use one over the other? thank you so much

 

[alansidman]

If you are working in more than one workbook or worksheets, then you may wish to use the first variation. For most situations, the second scenario should work for you.

 

[My Aswer Is This]

With Excel you can do almost anything several different ways.
Now which is best or fastest is all up for debate.
Here is another way:

[A1]= 10