Community archive

Ask something
Discussion Locked

laptopcheckouttool report function

0 helpful
1 reply

by brenda.lee

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

Range(FirstAddress).Select
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
Next

1 reply

by Greg Shultz

Brenda:

Have you downloaded the most recent version of this tool?

Can you print any of the reports?

How much data do you have in the spreadsheet?

Any other information you can provide might be helpful..

This discussion is closed to new replies.