Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross 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. SteveJL

    Excel VBA: Replace$: Sub or Function not defined

    Thanks CC. You are correct. The failing workstations (turns out there are more than one) are running with Excel 97. Replace$ is not supported under this version. The .xls was created with Excel 2002.
  2. SteveJL

    Excel VBA: Replace$: Sub or Function not defined

    I am using Replace$ in some VBA code in Excel without any problem. I have distributed the file to several testers and for the most part it's ok. However, one user is getting "Sub or Function not defined" and the Replace$ function is highlighted. Does anyone know why this is happening?
Back
Top