I am trying to move large quantities of information between two programs and
their only common format is Excel. However, the formatting of the cells is
different and I want to create a macro that fixes the formatting since this
will be done a lot. The problem is that I need to add a few columns. I am
currently dragging down to fill in the cells but the problem is that I don't
know the length of the file that the macro is working on. I need it to fill
down through the same row that the rest of the data ends at. The cells in
the columns being filled down each have the same word in them. Is there a
way that I can do this in the macro?