Hai i have an excel sheet, in that i need to calculate some values in row wise first i set the values in the starting cell(A1) from that i wants to fill the formula in next 10 cell continously in row wise(A1,B1,...). i already use the code to fill the formula in column wise the code is below Range("Q5" & Range("Q65000").End(xlUp).Row).FillDown. If you have any idea about the rowise Auto fill the formula then please guide me
+2
A:
the code that works for the column case, works even for the row case if you use Range.FillRight instead of Range.FillDown
Range("a1:z1").FillRight
vaitrafra
2010-06-03 13:29:48
raam
2010-06-03 13:43:42
Range("a1:t1").FillRighti've tested this on a Excel2003 Workbook and it runs smoothly.
vaitrafra
2010-06-03 14:40:27