Hi All,
I am trying to find a character in a cell and want to apply a formula for that.
basically i have excel formula which i am trying to use in VBA macro.
can any body help on this?
formula is --- =LEFT(C2,FIND(":",C2)-1)
the above formula i am trying to convert into vba macro code but no joy
But this code is not working, can you please help me out..
Sheets("Defects").Cells(i, 39).Value = Left(Sheets("Defects").Cells(i, 3).Value, Find(":", Sheets("Defects").Cells(i, 3).Value) - 1)
With Sheets("Defects") .Cells(i, 39).Value = Left(.Cells(i, 3).Value, Application.WorksheetFunction.Find(":", .Cells(i, 3).Value) - 1) End With
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sheets("Defects").Cells(i, 39).Value = Left(Sheets("Defects").Cells(i, 3).Value, InStr(1, Sheets("Defects").Cells(i, 3).Value, ":")-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks