Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Egidius Bakker   on Feb 15 In MS Office Category.

using values from one spreadsheet into another


  
Question Answered By: Mamie Wallace   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

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
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: