How do I show a sheet programmatically?

G

Guest

I have bunch of cells from different sheets in a datagrid (that datagrid is
attached to Excel workbook thru some addin). If there are 2 cells (like $M$8
from Sheet1 and Sheet2 in that datagrid) - when I click Sheet1$M$8 - then it
should hightlight sheet1 M8 cell and when I click Sheet2$M$8 - then it should
highlight sheet2 M8 cell - but right now when I select Sheet1$M$8 and
Sheet2$m$8 - it highlights same cell (M8 from sheet1) as my sheet1 is active
sheet at this point. How do I dynamically change sheets? any help is really
appreciated!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to match 2 column values in different sheets 1
Excel VBA to move cells to sheet2 based on selection in sheet1 0
loop to copy paste 5
Help to find and replace between sheets 1
Conditional formatting puzzle 2
compare value of cell in one sheet to range of another sheet 3
sheets that mirror each other 8
Selection on a non-active sheet? 2

Top