Help with VB Code

[sambf1991]

I'm trying to auto sort by value, but the cells in which the values are contain functions. I have a code for if they contain just numbers but is their a way to sort when containing functions?

My table looks like this

Base ----- Income ----- Cost ----- Income:Cost
Nuc ------- $$ --------- $$ ------- =(B2/C2)
Pow ------- $$ --------- $$ ------- =(B3/C3)
Com ------- $$ --------- $$ ------- =(B4/C4)
Sta -------- $$ --------- $$ ------- =(B5/C5)
Oil -------- $$ ---------- $$ ------- =(B6/C6)


I would like to autosort column D, descending.

Thanks in advance.

 

[taigovinda]

Welcome to the board!

What do you mean by "autosort?" When should the data be sorted? Generally, I would expect some specific range being typed into (column B or C?) to trigger a macro that simply sorts based on column D... I wouldn't think having those formulas in column D would change your procedure at all.

 

[sambf1991]

The "cost" is constantly changing for each base, meaning the income:cost ratio is also changing. I would like the bases to sort automatically by income:cost ratio.