Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |