$$Excel-Macros$$ EXCEL 2010 VBA File: Read-Only Workbook created using EXCEL 2003

2011-07-26 Thread JingleRock
I have seven users accessing the Subject file stored on a shared network drive. This file has been edited by EXCEL 2003 users (four of the seven in my group) for several months. Yesterday, I made some edits in this file when I opened it; I then saved it successfully with a .xls extension. One of th

$$Excel-Macros$$ Find and Replace Help

2009-08-07 Thread JingleRock
quot;STA", LookAt:=xlWhole, _ SearchOrder:=xlByColumns, MatchCase:=True When I step thru the Code, (current value of iTotalRecs is 1), I can see the specified range of E5:X6 is selected. However, only the 'STABLE' values in Row 5 are replaced. Please help. Jingl