98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Visual Basic
Excel Visual Basic
Resolved · Low Priority · Version Standard
Fri 15 Feb 2008, 15:46Delegate Xavier said...
Xavier has attended:
Excel VBA Intro Intermediate course
Excel Advanced - Formulas & Functions course
PowerPoint Intermediate Advanced course
Excel Visual Basic
Why Range uses "" and cells does not?
e.g. Range("A1")
Tue 19 Feb 2008, 15:58
Edited on Tue 19 Feb 2008, 15:59Trainer Carlos said...
RE: Excel Visual Basic
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |
