5/7/15:
Scenarios i wanted to implemente:
- I wanted to count the number of rows(with data) in excel sheet
- After applying filter, i wanted to count rest of the rows
- Create graph based on the data available in the table. select your own xaxis and yaxis.
- Refresh the excel data with macro, sometimes the formula doesnot get triggered
- I am trying to go through each and every filtered cell, if i used for loop using Range, it is going through each of the rows, that is even non filtered rows.
Scenarios i wanted to implemente:
- I wanted to count the number of rows(with data) in excel sheet
- After applying filter, i wanted to count rest of the rows
- Create graph based on the data available in the table. select your own xaxis and yaxis.
- Refresh the excel data with macro, sometimes the formula doesnot get triggered
- I am trying to go through each and every filtered cell, if i used for loop using Range, it is going through each of the rows, that is even non filtered rows.
No comments:
Post a Comment