Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Glenn Duncan   on Jan 03 In MS Office Category.

reading value from sheet1 into sheet2 using VBA


  
Question Answered By: Anthony Smith   on Jan 03

Any cell  in any worksheet can be referred to by being explicit thus:

Thisworkbook.Sheets("Sheet2").Range("C3")=ThisWork
book.Sheets("Sheet1").range("V45")

(those last two lines should be on one line)
or

ThisWorkbook.Sheets("Sheet1").range("V45").copy
Thisworkbook.Sheets("Sheet2").Range("C3")

(those last two lines should also be on one line)

Share: 

 

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

 
Didn't find what you were looking for? Find more on reading value from sheet1 into sheet2 using VBA Or get search suggestion and latest updates.


Tagged: