excel vba courses london - Macros

The UK's most regular instructor-led training courses.
Training information: excel vba courses london · Excel training london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Macros

Laurence has attended:
No courses

by - delegate Laurence [1 post] (2007 Mar 1 Thu, 09:58) Reply

help with how to move to next column in a worksheet to test the data in that column (e.g. if cell is blank) and then do something to that column, e.g. delete

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: macros

by - trainer Carlos gold contributer [479 posts] (2007 Mar 9 Fri, 16:03) Reply

From the little you have written you will need to do some VBA coding as a recorded Stand Alone macro won't do.

You will need to use Offset and an If loop to check the next column and do something to it

· Microsoft Excel Courses Teach Advanced Macro Techniques
· Crazy Things People Have Done With Excel
· Microsoft Office and the Small Business: Part 1 Excel
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Excel and Inventory Management

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.

Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.

To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips