RE: $$Excel-Macros$$ MID function (Search sentence between whole sentence) in ROW

Try below mentioned Change cell ref.. =LEFT(B27,LEN(B27)-FIND("MT.",B27,1)+3) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Tuesday, February 11, 2014 1:47 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MID functio

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

RE: $$Excel-Macros$$ how to get conditional formatting code already applied on a cell through vba

Try this Sub DataBarBook() Dim DB As Databar With Range("A2:A11") Set DB = Range("A2:A11").FormatConditions.AddDatabar() With DB.BarColor .Color = RGB(255, 0, 0) End With End With End Sub Thanks & regards,