So, I took off on Saturday morning to run some errands and to try to find a flea market that I heard was in Hinkley – well, needless to say, I was lead a stray – someone really needs to clean out the interenet! There is so much old crap on the internet that is set to autodate to current – a programmers trick, that I myself have used (Karma? Knocking on my door?) – so I made the best of a bad road trip. I got to stop at a Quilt shop that is up that way.
BIG MISTAKE – what oath did I take this year: No New Fabric This Year! Well considering I broke that oath about a month after I made it, I shouldn’t feel too guilty.
So I stopped at Fabric, Fashions and More in Rush City, and they always have fun sample quilts up and this time was no different.
- I could have taken home 8 kits, but I didn’t.
- I could have taken home 2 books, but I didn’t.
- I did however, bring home 2 small kits and I even started them.
- Even better, I finished one of them, well the top at least.
- Even better yet, I spray-basted 3 other tops that I had on the UFO pile
- And even better than that: I started quilting one of those sandwiches – I got almost exactly half way done and I ran out of bobbin thread – I took it as an omen, it was time to call it a night.
This weekend is a time of reflection and realization.
ALL LIVES MATTER!
Why is it that, all the news stories in the headlines today emphasizes what race the people are that are involved.
Every once in awhile I need to refresh my “geekiness” and do some programming. This week I had a project to take an excel file with 200 tabs (each employee had a tab with their information on it) and combine it into 1 worksheet so that it could be imported into a database without retyping all the information.
So I “googled” to see if I could find something that would do it, I found a couple of close ones, many way off ones so I took the best of them all and made this one.
- In preparing to run this macro I went into the first employee’s sheet and made sure that all the information was in A1.I1 – I used the “=F45″ to get the information from other places on the sheet to where I wanted it.
- I then copied that formula to all the tabs – tedious, but very effective. So I know had all the information I wanted to pull over into my one worksheet in the same layout and place on each tab.
- Then comes the macro:
- Creates another tab named “Combined” – which is also Sheet1
- Go to each tab in the workbook (Sheets.Count)
- Highlights the area that I have the formulas collection the information on each tab (A1.I1)
- Copies it (Selection.Copy)
- Make Combined Sheet the active sheet (Sheets(1).Activate)
- Go to the bottom of Column A in the worksheet – skip up to the last row of data in column A (the best way to explain this is if you were in the worksheet in column A, GoTo (ctrl-G) A65536 (way down the column) press the End key and then the Up key and it will bring you to the bottom of the data you collected). Then paste the values of what you copied in #D above.
Dim J As Integer
On Error Resume Next
Sheets(1).Name = "Combined"
For J = 2 To Sheets.Count
I had so much fun doing the last Mystery Quilt that I signed up for another one. I love these projects, breaks my promise of NOT buying any fabric, but I am having a lot of fun and that’s what it’s all about.
So the designer for the last one is doing another one, HeatherSpenceDesigns.com or join her fb group page: https://www.facebook.com/groups/mysteryquilt/ . The last one was so much fun and it’s a good cause, I’m in.
So I ordered my fabric and I’m ready. It starts on May 15, so I know what I will want to be doing that weekend.
Is it bad to hope for a rainy weekend?!
I picked the patriotic, sort of, colors since we’ll be finishing this at the end of June – theme based, love it!
I was so excited to start seeing the rows for the Minnesota Row by Row Experience but it seems that more than 1/2 the blocks being displayed around Minnesota are the applique style quilting this year. I did do 2 from last year that were applique and I just don’t enjoy that style at all. So I’m a bit disappointed now. I love the license plates, but not enough to travel around the state just to get those. I loved getting the blocks and trying new techniques that I had never done, fabrics and colors I don’t usually choose.
I’ve done the Quilt Minnesota shop hop a few years, but the last 2 years I really didn’t care for the material and I didn’t see any kits/patterns down with them that I was interested in.
It looks like this year, I’m going to have to find some other inspiration to keep me quilting.
Something that many others have not experienced in this day of moving every 5 years, is the evolution of your household. When I got married (1981) we soon purchased our first house. Never did we think we would still be in that house 30+ years later. We always thought this would be our started home. When we purchased our place, it was fairly new (the builder lived in it while he built it, so parts of it were 5 years old, parts were brand new). We are on 5 acres and all 5 acres were open field to the North West. Now, if you know anything about weather, the last thing you want is to be open to the North West! Our ‘development’ was 40 acres and during heavy snowstorms, gusty fall winds and monstrous thunderstorms we get all their debris. But it’s home! So for the first 5 years, we spent buying bundles and bundles of trees to plant to help build a natural wind break. This year, we have now reached the end of the live cycles of those trees that we fought so hard to grow those first years. Each year, from now on, we will have to take down 1-2 trees. It is amazing the difference in the yard with 5 dead trees being taken down can make. I think our front yard is 20% brighter now – I haven’t decided if that is a good thing or a bad thing – our lawn already would burn out by July.
We built this playground 25+ years ago
And held our breath
- What do you do when the 40+ ft tree has decided it doesn’t want to come down?
When something this big, starts to go down, or not in the case of this tree, you just hold your breath until it stops moving (or hangs on to another tree). It took us a couple of hours to get just this one, the biggest of all our trees, down. Only a few live branches were taken out by all the trees we took down, the playground survived – the slide does have one slight kink in it though, the firepit made it. Now, on to the cleanup.
The left overs
Never in my wildest dreams did I think that this mystery quilt would turn into this. I sat for over an hour trying to layout those pieces into something after last weeks clue. I was stuck on some kind of star, some how, most quilts are stars. Not this one.
Who would have thought this stack would turn into this.
This is going on TOP of the pile of quilt tops that I have to be done. This will make such an amazing picnic quilt. I did have to do a bit of ripping again this morning, but it was all well worth it.
I can’t say enough about this quilt. I am so in for the next one!!!!
I did this thru Missouri Star Quilting Forum and https://www.facebook.com/groups/mysteryquilt/ – the designer/hostess is Heather Spence.
Pinterest is bad, just bad I tell you.
I used to think that Google was an evil genius, Google has nothing on Pinterest.
We were looking for some things to make and donate to our fund raiser next week, so we all went to Pinterest. Being more than half of us are horse people we happened to run across a couple of horse shoe things and we were all over it.
I fell in love with the ribbons, right away, then I happened across the star. This this is so me: multidimensional, movement and horse related. YAH!!!!
So I sent Curt off to buy horseshoes. Of course we get all ready to make them and we say, lets start on Saturday so that, just in case we need anything we can run and get it. Famous last words, he got 2 stars done and 5 ribbons and ran out of stuff for the torch. And of course, you can’t get those filled on the weekend – what is with these companies that are only open 9-5 on weekdays!!!
Another successful Pinterest project!!!
We’ve all heard it.
We’ve all said it.
We’ve all NOT done it!
There is a piece missing in this well know piece of advice: “READ THRICE”
I started working on my Mystery Quilt for a Cure:
And I ‘thought” I was well on my way…little did I know I was going backwards!
We all have an Achilles heel – mine is when a situation requires a decision and both options are of equal value / deal / amount of work. A 50/50 is my worst nightmare.
So I cut up all my fabric into the strips, sewed them together (albeit incorrectly) and did all the sub-cuts. Then I got the next set of instructions….and I’m looking at it, and looking at it and noticing that my sub-cut strips are not like the others being posted on the blog.
I do the next natural thing – re-read the instructions. I did not arrange the fabric right when I put the strips together in step 1 – UGHHHHHHHHHHHH!
Now the conundrum – do I tear all the pieces apart and put back together or do I just get new fabric and start over. UGGGGGGGGGGGGGGHHHHHHHHHH! I’ve been stuck for a week now!!!!!!
Well, good intentions…what can I say.
They say ( who is they, by the way ) that new years resolutions are broken by the end of January. Sometimes, when it’s related to the gym it’s right about Feb 14 – who needs to be in shape after Valentines day, anyway?!
Well, my resolution was not to purchase any more fabric unless it was going to be used right away, for a specific purpose, immediately.
Well I made it to the First week in February. Although, I could argue, I did purchase fabric for a purpose, but “the proof is in the pudding” they say. ( Who is “they”? They are getting under my skin… )
I visit Missouri Star Quilt‘s site everyday to see the “Daily Deal” – right, it’s the last thing I need to do is have carrots dangled in front of me.
So, I am always up for doing something for a cause…..Well that’s my reasoning at least!!!