How do I even begin to express what I am feeling? When our friends found out we were going to move (about a year ago), this project was begun. Ellen Sorenson was the instigator and finisher. She planned out this friendship quilt and handed the plain fabric to friends. They were to combine it with a piece of their own fabric and make a windmill block. They signed their own block and returned it to Ellen who put them all together to form this beautiful creation! Then she mailed it to Claudia Fisher in Utah who machine quilted it!! Claudia mailed it back and Ellen put the edging on and bound it. The prairie points are made from leftover parts of the blocks! It is a masterpiece!

My recent post on embedding a Calendar control in an Excel sheet generated a lot of interesting questions. In this post, I’ll answer three of them: How to get a copy of the control How to control the position of the control How to hide the control How to get a copy of the Calendar control The easiest and safest way for Office 2003 users to get this control is to download and install Office 2003 Service Pack 3 . Be sure to install the file in the right folder: C:WindowsSystem32.

See original here:
How to acquire, position, and hide a Calendar control in an Excel sheet

My recent post on embedding a Calendar control in an Excel sheet generated a lot of interesting questions. In this post, I’ll answer three of them: How to get a copy of the control How to control the position of the control How to hide the control How to get a copy of the Calendar control The easiest and safest way for Office 2003 users to get this control is to download and install Office 2003 Service Pack 3 . Be sure to install the file in the right folder: C:WindowsSystem32

See the article here:
How to acquire, position, and hide a Calendar control in an Excel sheet

Many of us support Excel users and those users generate a lot of our calls! What problems or questions do you get the most calls for? If you don’t see it on the poll list, please add a comment below

Excerpt from:
Office poll: What’s your most common support call on Excel?

Many of us support Excel users and those users generate a lot of our calls! What problems or questions do you get the most calls for? If you don’t see it on the poll list, please add a comment below

Continued here:
Office poll: What’s your most common support call on Excel?

If an equation or formula attempts to divide a value by 0, Excel displays the #DIV/0! error, but that doesn’t mean the formula you’re using is wrong.

More here:
Inhibit Excel’s #DIV/0! error

If an equation or formula attempts to divide a value by 0, Excel displays the #DIV/0! error, but that doesn’t mean the formula you’re using is wrong. Most likely, the logic is sound enough

Continue reading here:
Inhibit Excel’s #DIV/0! error

The rents in the northern emirates have dropped considerably since 2009, given, the fresh supply and low demand. Even the lease rates have dropped 29 percent during the first half of 2009, says a CB Richard Ellis market report.

The trend is likely to continue into first half of 2010, due to weakening demand and huge supply from within the northern emirates and the border areas of Dubai, such as Muhaisanah, Al Nahda and Al Ghusais.

The demand is low or almost non-existent in the market, although the rental market is witnessing some movement, particularly from tenants seeking better quality property, said Mohanad Al Wadiya, Managing Director, Harbour Real Estate.

The maximum decline in rentals was noticed in the case of single bedroom apartments, which dropped 34 percent, while double and triple bedroom apartments dropped 29 percent and 25 percent respectively. This drop may be largely due to people opting for larger flats with lower rent on the offer in comparison to previous months.

Ajman and Ras Al Khaimah also witnessed drop in values by 50 percent or more for off-plan properties. The gaps between rental rates, however, remained the same among various northern emirates. Sharjah continued to demand highest rates, followed by Ras Al Khaimah, Ajman, Fujairah and finally Umm Al Quwain, the most affordable northern emirate.

Among these emirates, Ras Al Khaimah is witnessing maximum progress, while Sharjah and Ajman are on hold or are progressing very slowly.

Al Hamra Village is the only project with 90 percent completion rates, and 80 percent occupancy, with only one residential tower remaining to be completed in front of the resort. The rate at the Ras Al Khaimah’s Al Hamra village is 30 to 35 percent higher, in comparison to other developments in the region.

Also, the Bab Al Bahr project on Al Marjan Island, a sister development of Al Hamra Village, by Rakeen Properties, is also progressing on schedule. The first and second phases of the project are complete, while the third and fourth phases are nearing completion.

Even La Hoya Bay project by Khoie Properties, now undertaken by Rakeen, is being developed for delivery by 2011.

The Mina Al Arab development, the Pacific, all located at the Al Marjan Island is also due for delivery in 2011.

With more residents opting to move to border areas of Dubai, where there is better quality stock and competitive lease rates, the leasing rates across the northern emirates continue to decline in 2010, Al Wadiya said.

To add to this, high percent of residential accommodation is offered by the northern emirates, and this has stemmed from their fast-growing southern neighbour (Dubai), and this helped excessive expectations for new units, said Mat Green, Associate Director, CBRE – Middle East.

To prevent this exodus, landlords in the northern emirates are now offering rent-free periods of up to one or two months, free chiller, free parking spaces, and more such incentives, it is said.

If you use VBA with Word, you know that turning on the Macro Recorder is often the quickest way to automate a task. You could try to beat out the code yourself, but why work so hard when you don’t have to? Of course, you won’t always get exactly the code you need, but with a little tweaking, you can usually get the job done quicker by starting with the recorded code.

Read the original here:
Office challenge: What’s the quickest way to enable the Macro Recorder in Word?

Anyone entering dates should receive hazard pay. Even the best designed spreadsheet can confuse a user and frankly, it’s difficult to enter dates manually. Using the Calendar control can help.

Read the original post:
Automate an Excel calendar control