Assign value to named range.

[meinhunna]

I am refering a single cell using named range as follow:
oAmtAdded = [AmountOwing].Value

How can assign a value to the same range?
[AmountOwing].Value = 100 is not working

thanks

 

[palusa]

Did you try to prefix the cell name with its objectname such as ActiveSheet or SheetX or whatever? or to use the extended definition Range("AmountOwing")?

HTH

Luca

 

[Zathras]

The use of square brackets that way is kind of a short cut. Each of the following ways works. Take your pick:

Sub test()
  [AmountOwing] = 100
End Sub

Sub test2()
  Range("AmountOwing").Value = 200
End Sub

Sub test3()
  Range("AmountOwing") = 300
End Sub