hello Forum... i know very little of VBA... i do have these 2 codes in which i need in 1... any help is greatly appreciated
Sub ClockIn()
If Not IsClockedOut([employee]) Then
MsgBox "You must resolve the current issue first."
Exit Sub
End If
With clockdata.Range("A" & Rows.Count).End(xlUp)
.Offset(1, 0) = [employee]
.Offset(1, 1) = [Desc]
.Offset(1, 2) = [ID]
.Offset(1, 3) = Now
End With
End Sub
Sub red()
'
' red Macro
'
'
Range("B16:C16").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("A9:A16").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("D9:D16").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("A8:D8").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("A1").Select
End Sub
Bookmarks