Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Broken Array?
Hi everyone, I had a bit of code I was using: Code: -------------------- Case 1 Set wrkbkUrl = Workbooks.Open(Filename:="T:\afolder\3Networks\1 Network.xls") SHEETS(ARRAY(\"JAN\", \"FEB\", \"MAR\", \"APR\", \"MAY\", \"JUN\", \"JUL\", \"AUG\", \"SEPT\", \"OCT\", \"NOV\", \"DEC\", \"TEMPANALYSIS\", \"YEARLY SUMMARY\")).SELECT Cells.Replace What:="1st Network", Replacement:=strNetwork1, LookAt:=xlPart, SearchOrder:=xlByColumns, MatchCase:=False Sheets("Jan").Select Range("C3").Select -------------------- and it was working fine. But then I started altering other parts of the code (8 pages of A4 when printed of) to get rid of a couple of bugs that had, as far as I could see, nothing to do with this bit of code. Now, however, the macro just replaces the "1st Network" with the 'strNetwork1' variable in the "Jan" worksheet leaving the others alone Does anyone know why this would just break like this? -- Daminc ------------------------------------------------------------------------ Daminc's Profile: http://www.excelforum.com/member.php...o&userid=27074 View this thread: http://www.excelforum.com/showthread...hreadid=510568 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Broken Links | Setting up and Configuration of Excel | |||
Excel Broken? | Excel Worksheet Functions | |||
Broken Links.... | Excel Discussion (Misc queries) | |||
i think its broken | Excel Discussion (Misc queries) | |||
Tab Stop Broken | Excel Programming |