In column 15 today there is a following formula which is working as intended (Find the last cell with data..).
=LOOKUP(2;1/(F3:N3<>"");F3:N3)
The thing is that I would like to VBA to write this formula instead so I don't have to have the formula, just what is result in.
This formula is the same formula in every row until the last row. The only difference is that it changes what row the formula is using. Below is how the formula changes when you go down a row.
=LOOKUP(2;1/(F3:N3<>"");F3:N3)
=LOOKUP(2;1/(F4:N4<>"");F4:N4)
=LOOKUP(2;1/(F5:N5<>"");F5:N5)
I have tried to fix a code by myself which is not working right now because of simple mistake probably.
Can anyone explain what I do wrong in my code?
Bookmarks