Excel Visual Basic

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

Resolved · Low Priority · Version Standard

Excel Visual Basic

Xavier has attended:
Excel VBA course

by - delegate Xavier [3 posts] (2008 Feb 15 Fri, 15:46) Reply

Why Range uses "" and cells does not?

e.g. Range("A1")

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 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel Visual Basic

by - trainer Carlos gold contributer [360 posts] (2008 Feb 19 Tue, 15:58) Edited on 2008 Feb 19 Tue, 15:59 Reply

Hi Xavier

In Excel it is possible to name Ranges so when you refer to a range in VBA you do so using a string:

If you had named "A1" as "VAT" then in the VBA code you could either write

Range("A1") Or Range("VAT") as they would refer to the same cell

When using the Cells, this refers to the numeric co-ordinates of the cell's position on the worksheet

Cells(Row , Column)

So that Range ("A1") is Row 1, Column 1 which gives us

Cells (1,1)

Hope this helps

Carlos

· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Excel Macros for the Non-Programmer
· Advanced Excel Training - takes you to the next level
· Benefits of learning about Excel charts
· MS Excel: Excel At Making The Most Of Your Christmas

Please browse our web site to find out more about
microsoft-excel-courses and other Microsoft training courses.

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips