[Ganchrow]

Overlay

Please see attached Excel spreadsheet.

[Korchnoi]

should i be looking at 8 blank sheets, and two cryptic looking ones?

[Ganchrow]

should i be looking at 8 blank sheets, and two cryptic looking ones?

No.

[Ganchrow]

should i be looking at 8 blank sheets, and two cryptic looking ones?

No.

Meaning that if 8 sheets appear blank you, haven't looked hard enough.

[BigBollocks]

I'd love to give a whirl at this but unforunately don't have Excel on my personal computer, and can't get the free trial download through Microsoft to work....

[pico]

[Ganchrow]

Then either change your macro security level to medium (Tools => Marco => Security => "Medium" => OK) or you could just view the VBA code manually without running.

Doesn't much matter either way.

[pico]

hints?

[Ganchrow]

hints?

Were you able to open thej spredsheet?

[pico]

Were you able to open thej spredsheet?

yeah. i looked at the vb code too. pressed the button, garbage come out on cell A1...not sure why you were generating random crap in the vb code. found something on page 10 with SBR in certain places, also found a page with 18 (could be some other number, it was couple of days ago when i looked at it) in bunch of cells. not sure what to make of it.

[Ganchrow]

yeah. i looked at the vb code too. pressed the button, garbage come out on cell A1...not sure why you were generating random crap in the vb code.

---

Perhaps looking at the name of the button object as well as the two variables local to the event handler might suggest the answer.

---

found something on page 10 with SBR in certain places, also found a page with 18 (could be some other number, it was couple of days ago when i looked at it) in bunch of cells. not sure what to make of it.

---

I can assure you that every page has at least 1 non-empty cell, all of which are clustered together in a fairly small area. The first two pages have their non-empty cells along the edges. Using Excel's find function might be of use in locating the other non empty cells.

For how to proceed once you find the non-empty cells, consider the title of the puzzle.

---

[pico]

i cut and pasted all 9 areas with numbers. i assume the number means coordinates. 11 = (A1), 13=(A3), 23=(B3) etc. and i also assum that paste the areas on top of each other...in excel i did copy and paste special-skip empty. the way i used the number is to use that coordinate to paste the upper left corner for each of the square on top of each other. i did this for the 9 areas...not sure what to do with SBR. i did this, and i still don't see anything...i thought it would be some kind of picture or a word...but maybe i have not figure out the way you were thinking about this.

what am i doing wrong?

[Ganchrow]

i cut and pasted all 9 areas with numbers. i assume the number means coordinates. 11 = (A1), 13=(A3), 23=(B3) etc. and i also assum that paste the areas on top of each other...in excel i did copy and paste special-skip empty. the way i used the number is to use that coordinate to paste the upper left corner for each of the square on top of each other. i did this for the 9 areas...not sure what to do with SBR. i did this, and i still don't see anything...i thought it would be some kind of picture or a word...but maybe i have not figure out the way you were thinking about this.

what am i doing wrong?

---

Very close. You're certainly looking for the right thing. Just as you have intimated, the different pages are overlayed over one another, forming some clearly identifiable word or image.

Don't look for any hints by considering the contents of the different cell. The individual cell contents are another set of red herrings.

---

[pico]

i got that, but there are so many different permutations for overlaying 10 areas, i need another hint

[Ganchrow]

Solved by RickySteve on Wed Jun 20 at 15:08:30. RickySteve's Fortune: NEWS FLASH!!  Today the East German pole-vault champion became the West  German pole-vault champion.

__________________
This message was autoposted by ganchrow.

[Ganchrow]

Good job, RS. Well done.

There's really no "trick" here. You just need to take the time to puzzle through it.

Rearrange the pieces and a 6-letter word emerges.

[pico]

ganchrow, i think it is about time you post a solution to this puzzle

[Ganchrow]

ganchrow, i think it is about time you post a solution to this puzzle

I think it's about time you get to solving it.