Question

Write a VBA code to access the A4 cell of a worksheet directly using the cell object

​

Answer 1

Explanation:

Although Excel can work with three dimensional formulas the range object in VBA is limited to a range of cells on a single worksheet.

Answer 2

Answer:

Given below is the code

Explanation:

This is probably the question that is currently occupying your thoughts. While Cell is a property on an excel sheet, Range is an object in VBA. One approach to reference a cell object in VBA is through Range, and the other is through Cells.

You have two options for referencing a cell, for instance, if you want to refer to cell C5.

The Range Method ("C5") is used.

Using Cells Technique: (5, 3)

Similar to that, you may use the code below to put the value "Hi" into cell C5.

Range ("C5") method is used.

Value ="Hello"

Using Cells Technique: (5, 3).

Value ="Hello"

Now, the only way to pick numerous cells is using the Range.

See more:

https://brainly.in/question/18944059

#SPJ2