Every cell in column same formula

[Journeyman3000]

Hi All,

I'm looing for a vba method to assign a formula to every cell in a given column. I have multiple such columns into which a different formula needs to be written, and mulitple sheets.

I could use a loop, but that would be painful, slow and inelegant. Is there a better means to acheive?

Cheers

[alansidman]

Here are some samples of what you are looking to do.

Please Login or Register  to view this content.

[Ron Coderre]

It depends on the formula you want to put in the cells, but here's one approach:

Please Login or Register  to view this content.

Is that something you can work with?

[Journeyman3000]

Both of these examples will do perfectly. Thank you for your very quick response.

Reps to both of you.

Cheers