Fill down for all the cells
singh,
if you have a number in every single cell in column B down to the last row
of your data, select C1:D1 (or C2:D2 if your data starts in row 2) and
double-click the fill handle.
HTH,
Conan
"singh" wrote in message
...
Hi
Is there any way to fill down all the cells through macro only for filled
cells?
Simple Example
I have ten number in column A and same in column B in Column C i need sum
of
both the columns. column D multiplication.
For auto fill am using the below code apart from formula in cell C.
c=2
while range("A" & c).value < ""
range("C" & c).select
selection.filldown
c=c+1
wend
For D column I have to write the same code again. and if i have lots of
formulas in different columns the same thing continues.
Any solution.
|