Hi,
I am using below code inorder the fill the blank cell with the formula,the excel sheet contain data from A to R column,and the below coding fills the all the blank cells from A to R column But I need the macro to fill the blank cell only from A to I column and ignore the rest of columns.
Range("A1:I1").CurrentRegion.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
Range("A1:I1").CurrentRegion.Value = Range("A1:I1").CurrentRegion.Value
Thanks for help,
Harsha
I am using below code inorder the fill the blank cell with the formula,the excel sheet contain data from A to R column,and the below coding fills the all the blank cells from A to R column But I need the macro to fill the blank cell only from A to I column and ignore the rest of columns.
Range("A1:I1").CurrentRegion.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
Range("A1:I1").CurrentRegion.Value = Range("A1:I1").CurrentRegion.Value
Thanks for help,
Harsha