macro beginner error

Hi, I'm a complete macro noob. but i think I've got this worked out, at least in principle. I'm trying to use a value in Sheet1.Range("A1") to move to a certain row in Sheet2 and add a value. this is my code so far:

Please Login or Register  to view this content.

I get an error on the last line : ActiveSheet.Range.Cells(y, 1) = "some value"

does anyone have any insight on to what is going wrong.

Thank you

I got it working by omitting ActiveSheet.Range. from the last line

for anyone interested in this topic. this works

Please Login or Register  to view this content.

the tutorial i have been reading says the following:

The following three statements are interchangable

Please Login or Register  to view this content.

why did the code not work with the full path name? any insight is appreciated

thanx