Adding Cell value and a Value from name manager Range

[subbby]

hello all,

In my code on Sheet2 I have

Please Login or Register  to view this content.

• A is defined as Sheet1's Range("C12") . I defined this by adding it in the name manager

What I need : Cells(7, 8).Value = to be adding increment_value with Cells(6,8) value


Code I tried :

Please Login or Register  to view this content.

also tried

Please Login or Register  to view this content.

Error I am getting :
Run-time error '13' :
Type Mismatch

What Different things I tried :

• I changed initializing increment_value as long, single and integer and it didn't work

Any help is much appreciated.

Thanks in advance

[TMS]

See the code below ... you need the Range().Value

Please Login or Register  to view this content.

[subbby]

See the code below ... you need the Range().Value

Thank you very much. I understood what mistake I made.

To make it work to what I needed i changed this from your code

Please Login or Register  to view this content.

to the following

Please Login or Register  to view this content.

I got the hint from this line in your code

Please Login or Register  to view this content.

It worked like a charm. Really appreciate your time.

Thanks again

[TMS]

You're welcome. Thanks for the rep.