Q: "is there any solution for pick the step value in certain table?"
I'm sure that there is. We can easily give you answers. lots of answers. The problem is, they may not match up to your question. I'm not sure what the purpose or intent is for this. You seem to be highlighting the cell in which the row header and column header are the same. It happens that in the example, this also is where the row NUMBER and column NUMBER are the same, which may or may not be useful. but without knowing how the data is obtained, it's difficult to provide an answer to meet your needs. also, you said you want to "pick a step value". HOW do you want to "pick" it? That is, what do you mean by "pick"? Do you want a specific cell "selected"? what criteria is used to select a cell? what constitutes a "step"? what do you want to do with it when you "pick" it. Do you want to return the value to a VBA script? Do you want value to appear in a specific cell? Please elaborate. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Renukachari Kasee <jva.ch...@gmail.com> To: excel-macros@googlegroups.com Sent: Mon, November 19, 2012 12:06:41 PM Subject: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table Dear experts, is there any solution for pick the step value in certain table? please see above attached workbook here i need formula for pick the value thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
