Macro not referring to current worksheet

[c19h28O2]

Hi,

I have built a macro that refers to sheet1 i.e. sheet1.range("A1").value = "Hello World" how do i get the macro to refer to the activeworkbook? I have tried activeworkbook.sheets(1).range("A1").value but that doesn't work?

Thanks

C19

[Bob Phillips]

That works for me. In what way doesn't it work?