How to find Cell that contains a Range in Word VBA -


in word vba have reference range contained withing table cell.

how can reference containing cell (the innermost cell if there nested tables)?

what i'm trying achieve find cell containing range, move next adjacent cell.

this worked me:

debug.print rng.cells(1).next.range.text

-

Comments

Post a Comment

Popular posts from this blog

android - Scheduled sync adapter runs every 30 seconds -

i use sync adapters in application sync changes server periodically. no matter value put in pollfrequency sync runs every 30 seconds. i checked on forum , tried changes suggested in replies , pass 'false' synctonetwork parameter when raise notifychange on contentresolver. on going through training again in detail, stumbled upon difference. on google developer site -> training section sync adapters training see addperiodicsync -> pollfrequency parameter passed in milliseconds public class mainactivity extends fragmentactivity { ... // constants // content provider authority public static final string authority = "com.example.android.datasync.provider"; // account public static final string account = "default_account"; // sync interval constants public static final long milliseconds_per_second = 1000l; public static final long seconds_per_minute = 60l; public static final long sync_interval_in_minutes = 60l; //this line i'm referring...
Read more

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more