Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Harry Hunter   on Oct 19 In MS Office Category.

  
Question Answered By: Burkett Bernard   on Oct 19

So far I have been able to generate
the macro  that creates the puzzle.

But I need with coming up with 3 other macros.

One of the 3 macros is a macro that will find
and delete  the contents of those cells  below
whose background color(fill-color) is white:

-----------------------------------------------------------
A2:A4|B2:B4|C2:C4|D2:D4|E2:E4|F2:F4|G2:G4|H2:H4|I2:I4|J2:J4
-----------------------------------------------------------
A5:A7|B5:B7|C5:C7|D5:D7|E5:E7|F5:F7|G5:G7|H5:H7|I5:I7|J5:J7
-----------------------------------------------------------
A8:A10|B8:B10|C8:C10|D8:D10|E8:E10|F8:F10|G8:G10|H8:H10|I8:I10|J8:J10
---------------------------------------------------------------------
A11:A13|B11:B13|C11:C13|D11:D13|E11:E13|F11:F13|G11:G13|H11:H13|I11:I13|J11:J13
-------------------------------------------------------------------------------
A14:A16|B14:B16|C14:C16|D14:D16|E14:E16|F14:F16|G14:G16|H14:H16|I14:I16|J14:J16
-------------------------------------------------------------------------------
A17:A19|B17:B19|C17:C19|D17:D19|E17:E19|F17:F19|G17:G19|H17:H19|I17:I19|J17:J19
-------------------------------------------------------------------------------
A20:A22|B20:B22|C20:C22|D20:D22|E20:E22|F20:F22|G20:G22|H20:H22|I20:I22|J20:J22
-------------------------------------------------------------------------------
A23:A25|B23:B25|C23:C25|D23:D25|E23:E25|F23:F25|G23:G25|H23:H25|I23:I25|J23:J25
-------------------------------------------------------------------------------
A26:A28|B26:B28|C26:C28|D26:D28|E26:E28|F26:F28|G26:G28|H26:H28|I26:I28|J26:J28
-------------------------------------------------------------------------------
A29:A31|B29:B31|C29:C31|D29:D31|E29:E31|F29:F31|G29:G31|H29:H31|I29:I31|J29:J31
-------------------------------------------------------------------------------

Could you help me with that?

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Macro for One-Solution Puzzle Or get search suggestion and latest updates.


Tagged: