I want to use values  from one spreadsheet  into another spradsheet using
VBA. Would anybody tell me how I could write  the code  for the same.
Thanking you all a lot.

thanx for the support.. but would u please let me know
that how could I do it with the help of VBA..
Please reply.

The following will take the value in A1 of sheet1 and put it in A1 of
sheet2.

Sub subCopyA1()
Dim vlValue as Variant

vlValue = Range("A1").Value
Worksheets("Sheet2").Activate
Range("A1").Value = vlValue

End Sub