Hi all,
So I've scoured the internet the last few evenings trying to find a solution for what I'm trying to achieve, to no avail so here i am.
I'm a complete VBA beginner so I've found it difficult to translate similar problems into my own solution, i am trying though!
Basically:
I have Formulas in L2:Y2
I would like these to be copied and pasted into L3:Y3
Then i would like to formulas in L2:Y2 to be pasted as values.
And that is the code finished.
The next time i run the VBA it will find the last used row in that range, which will be L3:Y3, so it will copy L3:Y3 and paste it into L4:Y4 so i need the code to find the last used row in that range each time.
Hopefully someone can help as I'm pulling (what's left of) my hair out at the minute.
I've attached an example of the sheet which already has L2:Y4 used so you can see where I'm coming from.
Thanks.
Bookmarks