excel+courses+in+london - Excel VBA

The UK's most regular instructor-led training courses.
Training information: excel+courses+in+london · Excel training course · Microsoft Office VBA training

Resolved · Low Priority · Version Standard

Excel VBA

Chris has attended:
Excel VBA course

by - delegate Chris [1 post] (2008 Jan 10 Thu, 16:13) Reply

How would I use VBA to generate a string made up of the vowels within another string surrounded by the character either side of the vowel? for example Microsoft = microssof

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	4	book now	£475	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003/XP	2008 Sep 18 Thu + 19 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Sep 25 Thu + 26 Fri	Southwark	6	book now	£450	£485
2003/XP	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 45 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel VBA

by - trainer Katie gold contributer [208 posts] (2008 Jan 21 Mon, 16:41) Reply

Hi Chris,

I have passed on your question to my VBA colleague. Unfortunately, he's unavailable until next week. Sorry about the delay in response.

Katie

· A Beginners Guide To Formulas In Excel
· How to check for and reduce errors in Microsoft Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Tap the Power of Recorded Macros with MS Excel Courses

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips