First time posting on MrExcel. Been using forums for years and this has taught me a bunch about VBA coding. I have a project where I'm trying to loop through column A starting from the last cell with contents in it. I would like for the vba to loop upward repeating that cell value until new...