Hello,

I have built a macro in Excel 2000 that I want to run on any active sheet
that I am on in a workbook. However, I get the error in the subject line,
above, for the following code:

While Not LastColumn
If Cells(1, traces + 1).Value = "Volt" Then
traces = traces + 1
Else
LastColumn = True
End If
Wend

I know that typically one specifies the sheet by identifying Cells with
Sheet(1) or whatever, but I don't want this macro to be tied to any specific
sheet, only the one that is presently active.

Does anyone have any ideas?

Thanks in advance.