The following code was written in Win 2000 and excel 2000. It will be used on a machine that has Win xp and excel 2002. Is this going to be a problem? I tried it last night. When it got to FirstCell = ActiveCell.Address, it told me it could not find the project or library.
Sub Set_RRdata() 're-sets range "RRdata"
Worksheets("RR"
.Select
Application.Goto Reference:="rr_out"
ActiveCell.Offset(1, 0).Select
FirstCell = ActiveCell.ADDRESS
LastCell = [A65536].End(xlUp).Offset(0, 9).ADDRESS
Data_Range = FirstCell & " : " & LastCell
Range(Data_Range).Name = "RRdata"
End Sub
I would appreciate any help you could give me.
Sub Set_RRdata() 're-sets range "RRdata"
Worksheets("RR"
Application.Goto Reference:="rr_out"
ActiveCell.Offset(1, 0).Select
FirstCell = ActiveCell.ADDRESS
LastCell = [A65536].End(xlUp).Offset(0, 9).ADDRESS
Data_Range = FirstCell & " : " & LastCell
Range(Data_Range).Name = "RRdata"
End Sub
I would appreciate any help you could give me.