Author Topic: Excel: Cell Information for Formula  (Read 331 times)

int5749

  • Newbie
  • *
  • Posts: 8
Excel: Cell Information for Formula
« on: April 10, 2017, 07:43:21 am »
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

  • Tech Support
  • *****
  • Posts: 2113
    • WinBatch
Re: Excel: Cell Information for Formula
« Reply #1 on: April 10, 2017, 10:39:34 am »
"le succès est une terrible maîtresse"
(French translation), Bill Gates


td

  • Tech Support
  • *****
  • Posts: 2113
    • WinBatch
Re: Excel: Cell Information for Formula
« Reply #2 on: April 10, 2017, 11:16:19 am »
"le succès est une terrible maîtresse"
(French translation), Bill Gates


stanl

  • Pundit
  • *****
  • Posts: 630
Re: Excel: Cell Information for Formula
« Reply #3 on: April 11, 2017, 03:55:27 am »
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 .