Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

using values from one spreadsheet into another

  Asked By: Egidius    Date: Feb 15    Category: MS Office    Views: 909
  

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.

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Garai Chalthoum     Answered On: Feb 15

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.

 
Answer #2    Answered By: Caitlin Brown     Answered On: Feb 15

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

 
Answer #3    Answered By: Mamie Wallace     Answered On: Feb 15

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

 
Didn't find what you were looking for? Find more on using values from one spreadsheet into another Or get search suggestion and latest updates.




Tagged: