Re: Shift+Ctrl+Enter Into VBA

Quote from Batman;754173Display MoreHi,

Two problems:

1. In order to assign a formula to a range of cells in one statement, you need to use .FormulaR1C1 (with the formula defined in the R1C1 notation format), but this will not create the array formula you need. The alternative is to use .FormulaArray to put the formula into F2 and then .FillDown and .Calculate (depending on whether or not your macro has turned off automatic calculation).

2. Without seeing the data that you are trying to convert it's impossible to understand whether the formula can be changed so that it can be used in your macro. Can you upload a sample workbook?

Hi I attached a sample workbook,