Christmas lights macro

[pmolsen]

One minor correction. The Writei2c has to be on the same line as th
other stuff. I think it should read:

...
myStr = "writei2c w1,(%"
..

 

[Dave Peterson]

Your original post got hit by line wrap--so I matched what I saw <bg>.

Does this mean you got it working?

And (as a creature of habit (and copy|paste)), I sometimes add this:

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Short course:
Open your workbook
Hit alt-f11 to get to the VBE (where macros/UDF's live)
hit ctrl-R to view the project explorer
Find your workbook.
should look like: VBAProject (yourfilename.xls)

right click on the project name
Insert, then Module
You should see the code window pop up on the right hand side

Paste the code in there.

Now go back to excel and test it out--Tools|macro|macros...|Run
Testme

(but you should rename that to something meaningful.)