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 BlankNonAttendingDays() For iDay = 1 To 7 If Mid(ActiveCell.Value, iDay, 1) = Chr(154) Then 'MsgBox iDay With ActiveCell.Characters(Start:=iDay, Length:=1).Font .Size = 11 .Color = 192 End With End If Next iDay End Sub
|Column Layout in Access Xp VBA Report||3||19|
|VBA – How to copy a cell from one page and enter it into a new line on another page while selecting where the new line is added?||7||22|
|VBA question, how many data set exists in the sheet||14||53|
|Excel. How to get via VBA the last used row in a named dynamic range||10||31|