raw of code..

P

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 :)
 
P

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 ??
 
D

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)
 
P

pls123

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

Dave Peterson said:
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)
Click to expand...
 
J

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.
 
Top