Autofill Destination

Closed
tclouser Posts 1 Registration date Tuesday March 11, 2014 Status Member Last seen March 11, 2014 - Mar 11, 2014 at 12:54 PM
 clouser - Mar 13, 2014 at 01:49 PM
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

2 responses

Blocked Profile
Mar 12, 2014 at 04:49 PM
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!
0
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
0