MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Sub Set_Col_Wid_PM() Range("A1").Select Cells.Find(What:="PM", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=True, SearchFormat:=False).Activate Columns("E:E").Select Selection.ColumnWidth = 5.14 End Sub
= Set_Col_Wid("PM", 5.14)
|randomize data from excell cell||15||44|
|I need a formula to look in column U and tell me what cell is after 1/27/17 5 PM and before Monday 8am.||6||30|
|Hi All! How do I specify where a copied item is dropped?||3||24|
|I need to total a double column in Excel taking an alternate value if one exists||2||12|