filling down to the end of a data set automatically

E

eklem

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Filling in blanks 3
Getting Text data using the Data - Subtotal feature 1
Custom filling of cells 2
filling down a formula using =TEXT() 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
problem filling in blank cells with data above - 1
Macro to extend formulas 4

Top