{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lecture 20 - Using VBA with EXCEL

# Lecture 20 - Using VBA with EXCEL - Excel VBA Excel VBA How...

This preview shows pages 1–3. Sign up to view the full content.

11/30/2009 1 Excel + VBA Excel + VBA How this information will help you: learn how to read from and write to Excel files using VBA skills learn how to calculate lots of information very quickly in a nice format Connecting to your background Car mortgage House mortgage Student loans Planning for the future Making Decisions VBA skills

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
11/30/2009 2 Input/Output Reading and Writing I/O Cost = Range (“A5”).Value This will read what ever is in cell A5 and assign it to cost Cost = Cells (5,1).Value This will read whatever is in row 5, column 1 (A5) and assign it to cost Range(“A5”).Value = cost Whatever the value of cost is, it will be printed in cell A5. Cells(5,1).Value = cost Whatever the value of cost is, it will be printed in row 5, column 1 (A5) Things to Notice the quotation marks the .Value Cells(row, column).Value Input/Output Reading and Writing I/O Range(“A5:B12”)= cost The value of cost will be printed in all cells between
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 5

Lecture 20 - Using VBA with EXCEL - Excel VBA Excel VBA How...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online