apply formula to only those rows that are visible after sort

Hi,

I have created code to filter data in column E for specific criteria. Now I want to use a formula in column I for only those rows that are visible. The number of rows will change each week. Below is the code I have thus far. Thank you in advance for any help. I am still learning VBA a little at a time.

Please Login or Register  to view this content.

What is the formula you want to add?

BSB

=(Hx*1.5)*Gx where x equals the line number.

Maybe:

Please Login or Register  to view this content.

I have been busy working on other projects and just got back to this today. The code you sent me did not work. I need to apply the formula to all VISIBLE records in column "I". In the example I am working with, row 74, 75, 90 and 126 appear in the sort. Your code starts with I which is not part of my sort. I only need to apply the formula to those rows appearing after the sort. Any help at all to solve this problem would be greatly appreciated. Thank You!

Originally Posted by mlski4751

I need to apply the formula to all VISIBLE records in column "I".

Originally Posted by mlski4751

Your code starts with I which is not part of my sort.

I'm confused as these two statements appear to contradict each other.
Perhaps if you post a sample workbook and show which cells you want the formula added to that would help.

BSB

You're going to want R1C1 references since the first visible cell may not be in row 2:

Please Login or Register  to view this content.