Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. slystarnes

    "Right()" and "Left()" in VBA for XL2002

    I answered the post from 2 times ago already. Do you see the thread name? "Right()" only appears in one place in the section of code that I sent as a reply. Thanks for the help.
  2. slystarnes

    "Right()" and "Left()" in VBA for XL2002

    The variables are all defined above the part of the macro that I posted. When the error occurs, and I debug, the "Right" is the part that is highlighted. currRow = CInt(Right(ActiveCell.Address, Len(ActiveCell.Address) - 3)) This is the part that doesn't seem to be working.
  3. slystarnes

    "Right()" and "Left()" in VBA for XL2002

    For sex = 0 To 1 For Class = 0 To 4 For band = 0 To 4 currRow = CInt(Right(ActiveCell.Address, Len(ActiveCell.Address) - 3)) ActiveCell.Value = "=IF(B$17+$A" & currRow & ">100,0,VLOOKUP(""" & strSex(sex) & strClass(Class) &...
  4. slystarnes

    "Right()" and "Left()" in VBA for XL2002

    I am trying to use the "Right(string, #)" and "Left(string, #)" in Excel 2002, and when I run the macro, I get a "Compile Error: Can't find project or library." Am I missing an Add-In, or something? Or is this an invalid procedure in XL2002?

Part and Inventory Search

Back
Top