Tab

[guanoguck]

I am recording a macro that will put in the text "Staff Time Under 44 hrs" and then automatically tab over 5 cells. I cannot figure this out for nothing.

 

[Joe Was]

Sub MyTab()
'Standard Module code!
ActiveSheet.Select
Selection.Value = "Staff Time Under 44 hrs"
Selection.Offset(0, 5).Select
End Sub

Hope this helps. JSW

 

[lenze]

try adding
ActiveCell.Offset(0,5).Select

 

[guanoguck]

Thanks That Worked Great!!!!