Let me see if I can explain what the problem is:
This part of the code will ALWAYS place the formula in the last filled row of data in Column F AND Column H
So if you insert a row in Column F or in Column H the formula will in both columns move one down and you do not need to use the other twoo routines becuase they will not do the same
The following part of code is nonsense, you check the rows H1 - H500 and place the formula in H11 ?????
The same here:
The following part of code is nonsense, you check the rows F1 - F500 and place the formula in F11 ?????
If you use the code like this it will treat F and H differently
It all depends on what you want to do
Bookmarks