Can You Define a Function for an Entire Column in Excel Using VBA?

[cycling4life]

Is it possible to define a function for an entire column in excel? I have data importing from a chemical process simulator and every time it populates a row it will insert a blank row and I need to copy my formulas. Can I make it so, for example, column B is always equal to Column A+something, or etc?

 

[rcgldr]

You can enter =sum(...) into a cell to add up a list of values in a column or row of cells, for example, =sum(a1..a10) produces the sum of the column of cells a1 through a10.

 

[KingMike]

Create a template with the VBA function in the template...then use that template to make your sheet each time...that function will be available

 

[Adyssa]

Do you run a VBA routine to do the import, or manually import a text file, or is another program writing to the .xls file?

If you already have a VBA routine to do the import, you could just add a line to update the cell in column B for that row with your formula.