Thread
:
Column ROW CEL range vba
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Column ROW CEL range vba
IF I understand you want to copy from column 8 to column 5
cells(activecell.row,5).value=cells(activecell.row ,8)
--
Don Guillett
SalesAid Software
"Pieter" wrote in message
...
Thanks Don but that do not work when i am in row 30 for example
i want a macro to copy the value of column for example 8 and copy it as a
value to column Column 5 of the same row....
"Don Guillett" wrote:
try
range("d8").value=range("c8")
--
Don Guillett
SalesAid Software
"Pieter" wrote in message
...
Hello,
I need a macro that copy a value out of for example $C8 and copy it as
a
value to $D8 for example.
So macro must also work on for example ROW C25 and D25.
When i record the macro it only works with Row 8.
Can anyone help?
Thanks
Pieter
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]