eLCHa - tips and tricks for MS Excel: Contacts

eLCHa - tips and tricks for MS Excel

Stránky

Posts
Downloads
About the blog
Contacts

Translate

Featured post

Working with two monitors

Working with two monitors is realy great. There are keyboard shortcuts in Windows 7 that make the work with them much easier and faster ...

Contacts

Email:

Social networks:

Karel Koutný in Google+

Karel Koutný in LinkedIn

Search This Blog

All posts

A "text effect" in Headers or Footers
Array formula (CSE) in a VBA code
Blogger - a downloadable file with a counter
Easy and quick formula translation
F.Q.A.: A pressed key in VBA
F.Q.A.: FIND_FORMULA
Horizontal page breaks
How to change a formula
How to create an outline from a database
How to remove diacritical marks
Realtime filter of Listbox values through a Textbox
RichTextBox in Excel
Snake for Excel
The date of Easter
VBA - how to paste array formula to Table column
VBA - how to unzip or zip files
Working with two monitors

Popular posts

RichTextBox in Excel

I never needed a tool like RichTextBox in the Excel. But I've found out a lot of people want it. If you click on this link , you can ...
Realtime filter of Listbox values through a Textbox

I have a Userform with one ListBox and one TextBox. The ListBox contains data and I want to filter these data depending on the text in th...
How to remove diacritical marks

Have you ever deal with diacritical marks? Some languages contain characters with diacritical marks, even English language. To replace th...
VBA - how to paste array formula to Table column

If you are working with a Table (ListObject) manually, you can use an array formula. Simply past your formula with CTRL+SHIFT+ENTER. Ther...
Array formula (CSE) in a VBA code

Sometimes for continuing of a code we need to get a value from a range in the sheet. For example we have a range with numbers and we want...

Labels

AddIn (1)
Blogger (1)
Bug (1)
Excel (16)
Excel4Macro (1)
Formula (7)
FQA (2)
Game (1)
How To (11)
Immediate window (2)
UserForm (2)
VBA (13)
ZIP (1)

Subscribe To

Posts

Posts

All Comments

All Comments

This site uses cookies from Google to deliver its services, to personalize ads and to analyze traffic.
Information about your use of this site is shared with Google.
By using this site, you agree to its use of cookies.
Learn More

eLCHa. Powered by Blogger.