viewpoint-particle

Author Topic: Excel: Cell Information for Formula  (Read 225 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: 2053
    • WinBatch
Re: Excel: Cell Information for Formula
« Reply #1 on: April 10, 2017, 10:39:34 am »
"DON'T PANIC”
The Hitchhiker's Guide to the Galaxy, Douglas Adams


td

  • Tech Support
  • *****
  • Posts: 2053
    • WinBatch
Re: Excel: Cell Information for Formula
« Reply #2 on: April 10, 2017, 11:16:19 am »
"DON'T PANIC”
The Hitchhiker's Guide to the Galaxy, Douglas Adams


stanl

  • Pundit
  • *****
  • Posts: 612
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 .