Thread: [Solved] Copy/Paste/LastRow Help with Macro
View Single Post
 
Old 09-24-2016, 01:25 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,385
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by rsrasc View Post
The following code is an example of what I'm using to copy cell G17 ("ERPA") to cell A2 in "EPRALog", but what is doing is copying the formulas. I just want to copy the values. I tried several paste options but couldn't get it to work.
How about:
Worksheets("ERPALog").Range("A2").Value = Worksheets("ERPA").Range("G17").Text
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote