How to copy text between sheet?

[Chris]

Hello,

I have two sheets: sheet1 and sheet 2 in one workbook. In
the sheet 1: there are

Company Employee
A 10
B 9
C 7
D 5

so I write a macro,
If ActiveSheet.Cells(3, "B").Value = 9 Then
Sheet2.Cells(1, "A").value = sheet1.cells(2, "A")
end if

So the second workbook will look like
Company
B

THere is no error in my sytnax, but when I checked the
sheet2, the sheet is empty. What I have been doing wrong?

THanks

 

[Don Guillett]

works for me unless you the sheet index is wrong.

 

[Guest]

Hello,

It doesn't work for me. I have some radio buttons in
sheet2, will that be a reason? Is any alternative way to
do the same task?

Thanks

 

[Guest]

More information, it shows me an runtime error 424, Object
required.