By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 854 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

How can I copy the info I input on a cell (excel) to a different cell using macro?

P: 1
How can I copy a cell using macro, example whatever I input in cell a1 I need it to be inputed in cell g1.
Oct 29 '13 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 634
Hi

How about this
Expand|Select|Wrap|Line Numbers
  1. Option Explicit
  2.  
  3. Private Sub Worksheet_Change(ByVal Target As Range)
  4.     If Target.Address = "$A$1" Then Range("G1") = Range("A1")
  5. End Sub
??

This code is in the Sheet Module.

MTB
Oct 30 '13 #2

ADezii
Expert 5K+
P: 8,597
If you are not going to directly accessing Cell $G$1, but only using it for Referencing, then simply insert the Formula
Expand|Select|Wrap|Line Numbers
  1. =$A$1
into Cell $G$1
Oct 30 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.