Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel win2000 to excel 2002 xp

Status
Not open for further replies.

max1565

Technical User
Dec 16, 2002
57
US
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.
 
Anyone have any ideas on this? I searched the forum but never found a solution.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top