General discussion


laptopcheckouttool report function

By brenda.lee ·
When I click on the report button in the laptopcheckouttool program, it allows me to put in my preference for which type (quarterly...) to run but then it gives me the error
"Sub or function not defined". The sub is below.

ActiveCell.Offset(0, 2).Select
For X = 1 To ItemCount
Brand = ActiveCell.Value
If InStr(Brand, "+") Then
Brand = Replace(Brand, "+", "")
ActiveCell.Value = Brand
End If
ActiveCell.Offset(1, 0).Select

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums