variable not equal to expression
A real puzzler:
Dim pcol as Long
pcol = Target.Column
Target.Column shows as 16 (this is correct)
pcol shows as 17 (how can this be?)
This is embedded in a standard
Worksheet_Change(ByVal Target As Excel.Range) event macro
Excel 97 SR2, Windows 2000
Does anyone have any idea why this isn't working right?
All help is appreciated...
steve
|