Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I know how to write a VBA statement to select a range using a cell address, but how can I write a statement to select a range if I know only the row and column number?

April 26, 2017address CELL column range row select VBA write

0

Posted

I know how to write a VBA statement to select a range using a cell address, but how can I write a statement to select a range if I know only the row and column number?

1 Answer

0

Posted

Use the Cells method. The statement below, for example, selects the cell in the fifth row and the 12th columns.