I got it working by omitting ActiveSheet.Range. from the last line
for anyone interested in this topic. this works
Sub test()
'
' test Macro
' Macro recorded 11/27/2007 by none
'
'
Dim y As Integer
y = ActiveSheet.Range("A1").Value
Sheets("Sheet2").Select
Cells(y, 1) = "some value"
End Sub
the tutorial i have been reading says the following:
The following three statements are interchangable
ActiveSheet.Range.Cells(1,1)
Range.Cells(1,1)
Cells(1,1)
why did the code not work with the full path name? any insight is appreciated
thanx
Bookmarks