| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :) |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
| Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Linear Mode
