ExcelBanter - Clarification in vb excel programming

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Clarification in vb excel programming (https://www.excelbanter.com/excel-programming/372906-clarification-vbulletin-excel-programming.html)

[email protected]

Clarification in vb excel programming

Dear All,

"Sheets("Data").Cells((SheetCounter + 2), 2).Select"

What does the above mean? especially cells((sheet counter + 2),
2).Select.

Thanks in Advance,
Satya

NickHK[_3_]

Clarification in vb excel programming

Satya,
It means you will select the cell on worksheet "Data" that is located at
SheetCounter + 2 rows down and 2 columns across.
So somewhere in column B, depending on the value SheetCounter.

NickHK

egroups.com...
Dear All,

"Sheets("Data").Cells((SheetCounter + 2), 2).Select"

What does the above mean? especially cells((sheet counter + 2),
2).Select.

Thanks in Advance,
Satya

[email protected]

Clarification in vb excel programming

Nick,
I am new to excel sheet programming in VB.
Thanks for the quick response.

Thanks and Regards,
Satya.

NickHK wrote:
Satya,
It means you will select the cell on worksheet "Data" that is located at
SheetCounter + 2 rows down and 2 columns across.
So somewhere in column B, depending on the value SheetCounter.

NickHK

egroups.com...
Dear All,

"Sheets("Data").Cells((SheetCounter + 2), 2).Select"

What does the above mean? especially cells((sheet counter + 2),
2).Select.

Thanks in Advance,
Satya

All times are GMT +1. The time now is 09:49 PM.