Hi all,

The workbook I have built, based on several input tabs, spits out XML code that can be easily copied over to Notepad ++ to be utilized by a developer. The LAST little tweak I'd like to make is to be able to tie a macro to a form control button that highlights and copies the code. The code can be outputted from B1 - B393, but the reason I'm having trouble is because depending on who's using the workbook, the length of the code can vary greatly. In my test example, the code ends at B:302, but since I have formulas in every cell up to B393, I can't figure out how to easily create a way to highlight and copy on the cells in that range that "aren't blank". I've tried to make a dummy column, but it isn't dynamic if the length of the code changes.

In summary I want the macro to highlight and copy all cells in B1 - B393 that are not blank. Thank you in advance for your help, If something doesn't make sense please let me know!