vb.net - How to set different freeze panes for different sheets in an Excel using VBA -


i want set different freeze panes different sheets in excel. tried using below code being assigned sheets. want freeze first 6 rows in first sheet , top row in second sheet. tried many ways no result. suggestions? 

with xlapp.activewindow     .splitcolumn = 0     .splitrow = 6 end

the full code (from comments) is:

dim xlapp application  dim xlwb workbook  'dim xlws worksheet  xlapp = new application()  xlwb = xlapp.workbooks.open(csfilename)  xlapp.activewindow    .splitcolumn = 0    .splitrow = 6  end

try out, replacing sheet names, rows & columns appropriate values:

worksheets("sheet1").activate activewindow.splitcolumn = 0 activewindow.splitrow = 6  worksheets("sheet2").activate activewindow.splitcolumn = 5 activewindow.splitrow = 11  worksheets("sheet3").activate activewindow.splitcolumn = 10 activewindow.splitrow = 16

based on code posted in comments, should work:

dim xlapp application  dim xlwb workbook  xlapp = new application()  xlwb = xlapp.workbooks.open(csfilename)  xlwb.worksheets("sheet1").activate xlapp.activewindow    .splitcolumn = 0    .splitrow = 6  end xlwb.worksheets("sheet2").activate xlapp.activewindow    .splitcolumn = 0    .splitrow = 1 end

i recommend always explicitly specifying sheet want active this, since requires activewindow in order function, way won't ever accidentally on wrong window when you're setting split rows.

dim xlapp application  dim xlwb workbook  xlapp = new application()  xlwb = xlapp.workbooks.open(csfilename)  xlwb.worksheets("sheet1").activate xlwb.worksheets("sheet1").range("a6").select xlapp.activewindow.freezepanes xlwb.worksheets("sheet2").activate xlwb.worksheets("sheet2").range("a2").select xlapp.activewindow.freezepanes

Comments

Post a Comment

Popular posts from this blog

IF statement in MySQL trigger -

this query code in mysql trigger. if 1=2 select 'yes'; else select 'no'; end if; but has following error: if '1'='2' select 'yes' error code: 1064. have error in sql syntax; check manual corresponds mysql server version right syntax use near 'if '1'='2' select 'yes'' @ line 1 0.000 sec what solution?
Read more

c++ - What does MSC in "// appease MSC" comments mean? -

i run across // appease msc in c++ comments, e.g. here : const int& array::operator[](int offset) const { int mysize = getitssize(); if (offset >= 0 && offset < getitssize()) return ptype[offset]; throw xboundary(); return ptype[offset]; // appease msc! } what msc stand ? the author means microsoft's compiler, more formally known msvc.
Read more

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -

i run blogger blog , use follow code javascript code (requires no jquery) show related post labels/categories of post. <script type='text/javascript'> var defaultnoimage=&quot;http://1.bp.blogspot.com/-m72rpguntq0/vuokijudn_i/aaaaaaaaboi/lq18sceunsg/w72/favicon-tik.png&quot;; var maxresults=16; var splittercolor=&quot;#d4eaf2&quot;; var relatedpoststitle=&quot;related posts&quot;; </script> <script type='text/javascript'>//<![cdata[ var relatedtitles = new array(); var relatedtitlesnum = 0; var relatedurls = new array(); var thumburl = new array(); function related_results_labels_thumbs(json) { (var = 0; < json.feed.entry.length; i++) { var entry = json.feed.entry[i]; relatedtitles[relatedtitlesnum] = entry.title.$t; try { thumburl[relatedtitlesnum] = entry.media$thumbnail.url } catch (error) {...
Read more