c19h28O2
02-17-2006, 03:20 AM
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
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