I need some help modifying the following macro

[suprsnipes]

I need some help modifying the following macro.

Sub YHOO_Buy()
Dim Id As Long

req = "buy_1000_YHOO'"

Id = Round((Date - 39000 + Time) * 1000000, 0)


ActiveCell.Value = "=dem|ord!'id" & Id & "?place?" & req

End Sub

I want to change the ActiveCell to a specific address, in this case A1. In what way do I need to modify the above macro?

Regards,
suprsnipes

 

[Ruddles]

Instead of ActiveCell use Range("A1").

Although to be honest it's always better to reference these things explicitly, that is to say, don't assume that the correct workbook and worksheet are always the active ones otherwise you might be writing to the wrong place.

So perhaps ThisWorkbook.Sheets("Sheet1").Range("A1") might be better. (Modify the sheet name to suit.)

 

[suprsnipes]

Perfect, thanks very much.