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: Clarence Nichols on Jan 03

I notice if you just add ".Value" after each statement it also work.

Thisworkbook.Sheets("Sheet2").Range("C3").Value =
ThisWorkbook.Sheets("Sheet1").Range("V45").Value

Would there be something drastic wrong with this?

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.

Related Topics:

Replacing shapes on sheet1 with shapes from sheet2
VBA to Change value in column AQ based on values in I, and AI
Using VBA To get and write values from other workbooks
how to make the macro keep working after deleting the sheet2 and chart
Read VB code with VBA
VBA Array - return value to a cell
VBA code to add values in two cells which have formulas
capture DDE update value in VBA macro
VBA Vlookup returning wrong values
Looped VBA to paste special values
Fill VBA form with Cell values of an Excel sheet
VBA code to convert all values of a column in a row separated by semi colon
Convert code from excel 2000 vba to excel 2003 vba
writing vba code to generate vba code
Cannot use the VBA add table command of MS word in MS Excel VBA
writing vba code to generate vba code
Cannot use the VBA add table command of MS word in MS Excel VBA
Placing VBA Code "Live" Into Another WkBook Via VBA
Read pixel value
Reading Empty Value from SQL Server 2000 & writing to the XML

Tagged:reading value from sheet1 into sheet2 using vba

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us