I am trying to create in my macro a way to paste to varying row lenths.
This is what I have, but it keeps putting a cell address instead of say over 2 cells. You can see it puts a range of E451. This will change every time. Range("E451").Select
Your help is greatly appreciated. I will use...