How to copy a formula to every other column

[Pandrade]

Hi,
How can I copy a formula with more than a thousand columns to every other column in Excel?

 

[COwen]

To every other column? There are over 16,000 columns in Excel. how does a formula have over 1000 columns? Please explain your requirement more clearly.

 

[Tom.Jones]

Hi,

Say in A1 it is your formula. In B1 put this formula:
=IF(MOD(COLUMN();2)=0,"", put your formula here) then drag to right.

 

[Anthony47]

If you want to do that via vba, something like

    Range("A2").Copy
    Range("B2:AAZ2").PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False

Adapt the ranges to your context

Bye

 

[COwen]

Do you want "the formula" to retain its cell references, or do you want them to change?

 

[COwen]

@Anthony47 good, quick solution

 

[COwen]

@Anthony47 will not work if @Pandrade wants it to increase the range references.

 

[Anthony47]

My formula is a "concept"; without additional info from @Pandrade I cannot suggest an exact approach
Bye

 

[Pandrade]

Hi Anthony,
Thanks for your help. The formula will count the cells in each column that have data in them.

 

[Pandrade]

Each column is different and some columns have more or less data. The formula to be copied across to every other column will count the number of cells that have data in each column.