Excel: Cell Information for Formula

Started by int5749, April 10, 2017, 07:43:21 AM

Previous topic - Next topic

int5749

Hi all,

I created a Winbatch Script which fills data into an Excel => So far so good and working fine

I'm doing this while counting row/column.

Now I have to put a formula into cells of a specific column but "cells(1, 1)" doesn't work while "A1" is expected.
e.g. I have to fill in a formula "=COUNTIF(E2:N2;"X")" after I added 10 Columns after starting on column 5 (aka => E)

Any idea hwo I can manage this??

Regards and thanks,
joerg

td

"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

td

"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

stanl

Not to intercede, but are you trying to include the Countif() formula in your code, or populate cells in a template where the formula is expected to execute.  If the former, look into .FormulaR1C1 .