Question

how will you refer to a range of cells from a1 to g5​

Answer 1

Answer:

ExplanSub FormatRange()  

Workbooks("Book1").Sheets("Sheet1").Range("A1:D5") _  

.Font.Bold = True  

End Subation:

Selection using the interface: click on cell A1, position your mouse over cell C5, press and hold <Shift> and click on cell C5. Your range should be highlighted.

Reference Meaning

Range("A1") Cell A1

Range("A1:B5") Cells A1 through B5

Range("C5:D9,G9:H16") A multiple-area selection

Range("A:A") Column A

Range("1:1") Row 1

Range("A:C") Columns A through C

Range("1:5") Rows 1 through 5

Range("1:1,3:3,8:8") Rows 1, 3, and 8

Range("A:A,C:C,F:F") Columns A, C, and F

Answer 2

Answer:

Hey Mate

Here is your answer.…..

.

.

You can refer to a cell or range of cells in A1 reference style by using the Range property.

.

.

Hope it helps you...