Tomorrow'sYesterday
New member
- Dec 20, 2010
- 4
- 0
- 1
I need to make a Macro out of the following:
I have two columns. One column contains data (which varies day-to-day -- sometimes it is 40,000 rows; while some days it is 60,000 rows)
While Column B is filled with the numbers (that range from 40,000 to 60,000 rows)
I need to take Column A and make it so it "Auto-fills" the entire Column with the letter "Add" -- but I do not know how to make it so the Macro will Auto-Fill exactly to where Column B ends. I.e., I need Column A to auto-fill with the word "Add" all the way to the very last number in Column B AND it wont:
(1) Keep going past the Column B's range
and/or
(2) Stop before it hits Column B's range.
Remember, it is easy to do it without a macro -- but I do not know how to make it so a Macro will know when to stop "filling" the Column with the word "Add"
I have two columns. One column contains data (which varies day-to-day -- sometimes it is 40,000 rows; while some days it is 60,000 rows)
While Column B is filled with the numbers (that range from 40,000 to 60,000 rows)
I need to take Column A and make it so it "Auto-fills" the entire Column with the letter "Add" -- but I do not know how to make it so the Macro will Auto-Fill exactly to where Column B ends. I.e., I need Column A to auto-fill with the word "Add" all the way to the very last number in Column B AND it wont:
(1) Keep going past the Column B's range
and/or
(2) Stop before it hits Column B's range.
Remember, it is easy to do it without a macro -- but I do not know how to make it so a Macro will know when to stop "filling" the Column with the word "Add"