creating macro for copying the value from one cell
hi,
I m new to macro section. . If i m selecting a2 cell then the value will be captured in a3 cell r anyother cell i want. I want to know the function. plz guide me. |
creating macro for copying the value from one cell
Try using the Macro Recorder........the following is a simple one that I
recorded to answer this post....... Sub Macro1() ' Macro recorded 2/2/2007 by CRober Range("A2").Select Selection.Copy Range("a3").Select ActiveSheet.Paste End Sub Also, check out this link for help with macros, and post back if you have more questions. http://www.mcgimpsey.com/excel/index.html#usingvba hth Vaya con Dios, Chuck, CABGx3 "ananthu" wrote: hi, I m new to macro section. . If i m selecting a2 cell then the value will be captured in a3 cell r anyother cell i want. I want to know the function. plz guide me. |
All times are GMT +1. The time now is 01:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com