We help IT Professionals succeed at work.

vba question

How do I copy the formula in cell c2 all the way down to C135 with VBA?  I also want it to be relative to where the data in column B ends...as this will change.
copy-down-formula-even-though-bl.xls
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Range("C2").Copy Range("C2:C" & Range("B" & Rows.Count).End(xlUp).Row)

Explore More ContentExplore courses, solutions, and other research materials related to this topic.