raw of code..
 

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

raw of code..
 

Maybe

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

Mike

"pls123" wrote:

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

raw of code..
 

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




"Mike H" wrote:

Maybe

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

Mike

"pls123" wrote:

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

raw of code..
 

maybe this?

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


--


Gary

"pls123" wrote in message
...
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 :)

raw of code..
 

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 wrote:

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

--

Dave Peterson

raw of code..
 

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



"Gary Keramidas" wrote:

maybe this?

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


--


Gary

"pls123" wrote in message
...
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 :)

raw of code..
 

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

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson

raw of code..
 

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.

"pls123" wrote:

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




"Mike H" wrote:

Maybe

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

Mike

"pls123" wrote:

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