Thread: Input formula into a column via macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
franciz franciz is offline
external usenet poster
  
Posts: 79
Default Input formula into a column via macro
Hi

How can I input this formula into col P via a macro

=INDEX([FXAppl.xls]Sheet1!$C$1:$C$100,MATCH(LEFT(Sheet3!A1,4)&"*",[FXAppl.xls]Sheet1!$B$1:$B$100,0))

thanks

regards, francis
Reply With QuoteReply With Quote