Forum Discussion
UdayaChapal
Feb 07, 2020Copper Contributor
Populating Formula in a table column
I am simulating a problem that I have with another file with lot of macros and code etc. That file was working on every machine, except mine.
I have a table with three columns.
Table Name : MonthTable
Columns : Month1, Month2, Month3
I am trying to populate a formula in Month2 using the formula below.
Range("MonthTable[[#Headers],[Month1]]").Offset(1, 1).Formula = "=1"
I am expecting it to populate the entire column. But it is populating the formula in one cell only. Are there any special table settings I need to check or options to make it work on my machine ?
1 Reply
- Riny_van_EekelenPlatinum Contributor