Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am trying to write a quick macro to insert the content of a specific cell from a 1 column array. I am not sure of the syntax when you use an existing function in a macro, which probably explain why it does not work. Here's the quick macro Thank you. Eric. Sub Macro1() ' ' Macro1 Macro ActiveCell.FormulaR1C1 = Index(Client_List, Client_Selection) Range("K20").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to add a formula using a macro | Excel Worksheet Functions | |||
Macro formula help | Excel Worksheet Functions | |||
Formula - Macro | Excel Discussion (Misc queries) | |||
Formula or Macro Help | Excel Discussion (Misc queries) | |||
Do I need a formula or Macro? | Excel Worksheet Functions |