GridView Change row script pulls

[chrisjordan1978]

I have this in my excel macro. How can I change this so the row of the grid is pulled from my spreadsheet. Cells(currentRow, 6).Value = GridView.GetCellValue(6, "BALANCE_CUM") 'Cumulative Balance. Right now it is pulling row 6. They needs to change depending on the month.

[lenastodal]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.
For example, you can:
- outline what steps you took to find answers (and why they weren't helpful)
- share screenshots of what you've seen/done
- make sure you've applied the appropriate tags

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM