excel - How do I get the cell address of a table header cell? -

-

i'm using activesheet.listobjects(1).listcolumns(1) pick table header cell , i'm using activesheet.listobjects(1).listcolumns(1).name value of header. how address? example, i'd know if table header i'm targeting in column c , row 3.

i tried using activesheet.listobjects(1).listcolumns(1).address doesn't seem right.

a listcolumn has properties of databodyrange , range. range includes header cell, can find first cell of range.

dim col listcolumn  set col = activesheet.listobjects(1).listcolumns(1) msgbox col.databodyrange.address    'just data range msgbox col.range.address            'includes header cell  msgbox col.range.cells(1).address   'the header cell

hint: creating reference col means can make use of intellisense discover members of listcolumn object.


Comments

Post a Comment

Popular posts from this blog

node.js - NodeJS remote terminal to Dropbear OpenWRT-Server -

-
i wandering whether there valid solution have remote terminal openwrt-box out of nodejs-app? connecting terminal works: ssh -i ~/.mykeys/id_rsa root@192.168.178.39 busybox v1.23.2 (2015-04-22 23:25:48 utc) built-in shell (ash) root@openwrt:~# the only interactive ssh solution nodejs doesn't interactive part described in readme.md following: var client = require('ssh2').client; var conn = new client(); conn.on('ready', function() { console.log('client :: ready'); conn.shell(function(err, stream) { if (err) throw err; stream.on('close', function() { console.log('stream :: close'); conn.end(); }).on('data', function(data) { console.log('stdout: ' + data); }).stderr.on('data', function(data) { console.log('stderr: ' + data); }); stream.end('ls -l\nexit\n'); }); }).connect({ host: '192.168.100.100', port: 22, username...
Read more

Qt4: how to send QString inside a struct via QSharedMemory -

-
i have struct struct control_data{ int column_number; qstring cell; }; i need send thread of qsharememory. read can't because qstring contains pointers inside. other ways? you have serialize struct byte array. can convert qstring const char* this: mystring.tostdstring().c_str(); but serializing qstring should work. the first step serialize struct qdatastream using qt, example here . then once struct can read , written can pass shared memory. a complete example of using qsharedmemory can found here . here relevant code: // first, test whether shared memory segment attached process. // if so, detach if (sharedmem.isattached()) { sharedmem.detach(); } ... qbuffer buffer; buffer.open( qbuffer::readwrite ); qdatastream out( &buffer ); out << youstruct; int size = buffer.size(); // size of int + size of qstring in bytes if ( !sharedmem.create( size ) ) { return; } // write shared memory sharedmem.lock(); char *to = (char*...
Read more

php - Hide output during test execution -

-
i have var_dumps in php code (i understand there must none in end, still), , while tests running outputs non necessary information console, there method ignore code execution? i've tried /** * @codecoverageignore */ and // @codecoverageignorestart print '*'; // @codecoverageignoreend but ignores coverage, , still executes code. you can set setoutputcallback nothing function. effect suppress output printed in test or in tested class. as example: namespace acme\demobundle\tests; class nooutputtest extends \phpunit_framework_testcase { public function testsuppressedoutput() { // suppress output console $this->setoutputcallback(function() {}); print '*'; $this->assertfalse(false, "don't see *"); } } you can find reference in doc hope help
Read more