Re: $$Excel-Macros$$ Lock only column in vba

Hi please find below snapshot. i used sumifs formula and get value in cell D4 using VBA code as below. "=SUMIFS('Audit details'!$L$3:$L$54,'Audit details'!$H$3:$H$54,Sheet2!$B3,'Audit details'!$B$3:$B$54,Sheet2!D$2)" in which the yellow highlighted cell refers the agent AAA, when i run the macro

RE: $$Excel-Macros$$ Lock only column in vba

Hi Prabhu, You can use.. I = 1 Range("A1:A" & i) I = I + i === Cells(i ,"a") Use I counter to increment the row no. Hope it will help Thanks & regards, www.MrExcel4U.com From: excel-macros@googlegroups.com [mailto:excel-macr