Autofill Destination Closed

Question

I created a macro to add a column and then to make the number in the column to the left of that column a negative number.  I do that in the first cell selected in the new column and then will autofill to the bottom of the column.  The problem is when I run this macro there will always be a different number of cells in the left column that i need to copy to make negative.  How do I get the auto fill to do just two or hundred when i run the macro?  Thanks

ac3mark · Answer

tclouser,

Will you post what your code looks like?  Let us have an idea of where you are stuck, as there is no progress in re-inventing the wheel.   Thank you!

clouser · Answer

yes.  this is what i came up with so far on my code

Selection.AutoFill Destination:=Range("D5:D" & Range("C" & Rows.Count).End(xlDown)

this actually is working but now the next thing I need help with.  Is this code goes down the whole column of D, to infinity and beyond.  What i need now to tell it is to stop at the first blank in column C. Does that make sense

Autofill Destination

2 responses

Similar discussions

Subscribe To Our Newsletter!