raw of code..

[pls123]

hello everybody !!

i have to make a little piece of code for copying a certain cell to another...
but..

i have to copy in Range("F18").Value .......
the Value of "D34" .....
where D34 is composed by D & the number in cell "A2" that is 34 or
35 or any other !!!

help me pls

 

[Mike H]

Maybe

Range("F18").Value = Range("D34").Value

Mike

 

[pls123]

hehhe but 34 is not ever 34..
it can be a number that I indicate in another cell...

can that be done without opening vbe every time ??

 

[Gary Keramidas]

maybe this?

range("f18").Value = range("d" & range("A2")).Value

 

[Dave Peterson]

With activesheet
.range("F18").value = .range("D" & .range("a2").value).value
'or you may find this easier:
.range("F18").value = .cells(.range("a2").value, "D").value
end with

Another alternative is to use this in F18:
=indirect("D"&a2)
or
=index(d:d,a2)

 

[pls123]

yesss
ty gary i losted myself in a glass of water !!

 

[pls123]

TY Dave I will use if there will be any problm !

With activesheet
.range("F18").value = .range("D" & .range("a2").value).value
'or you may find this easier:
.range("F18").value = .cells(.range("a2").value, "D").value
end with

Another alternative is to use this in F18:
=indirect("D"&a2)
or
=index(d:d,a2)

 

[JLGWhiz]

It should not matter what D34 is comprised of. The value of D34 is the value
of D34. ergo: Range("F18") = Range("D34").Value should do the trick.