confused as to what [&]

[Gregfox]

1.I am confused as to what [&] means does itdenote what is between the [&] is a string like:

& this is a string & ?

2 If I want to put a formula in a certain cell like J2 to be (B2 – NamedCell) would I;

[COLOR=#000000][FONT=Calibri]DIM ABC as string [/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri]ABC = NamedCell    ; set ABC as a named cell
[/FONT][/COLOR]
[COLOR=#000000][FONT=Calibri] Range(J2).Formula =  “=(“B3” -  “& ABC &”)”    ‘? I’m confused about the quotes and the prentices[/FONT][/COLOR]

Thank you

 

[shg]

Range("J2").Formula = "=B2 - ABC"

You don't need any parentheses.

 

[Gregfox]

Thank you. can you explain &?

 

[Gregfox]

DIM ABC as string
ABC = NC   'where NC is a named cell
Range("J2").Formula = "=B2 - ABC"

The above didn't work and resulter in #NAME error in J2 [$150 - #NAME ]
any thoughts?

 

[fhqwgads]

i'm not really sure how named ranges work in VBA but i assume it's referring to something through code

Range("J2").Formula = "=B2 - ABC"

having ABC in quotations will make it into a string so in cell J2 you probably have the formula =B2 - ABC
maybe change it to

Range("J2").Formula = "=B2 -" & ABC

i'm not great on technical details and stuff but i always just thought of & as something that combines things into a string, and using quotations turns things into text. so like if you go to a cell and put in =A1 it will return whatever value is in cell A1, but if you put ="A1" the cell will just have the text A1 in it

 

[Gregfox]

Thank you.

 

[Michael M]

Maybe this

Dim abc As Range
Set abc = Range("NC")  'where NC is a named cell
Range("J2").Formula = "=B2 -" & abc & ""

 

[Gregfox]

This last code did it. I guess the trick was to use Range.
Thank you!