excel vba - Using VBA to return the Table Name corresponding to a given ActiveCell Selection -

-

for given activecell in excel how can vba return table name appears in properties grouping becomes visible when table tools design tab activated. example in immediate window:

?activesheet.listobjects(2)   table3600

but if select cell (potentially within table) can't seem find property either return selected cell's containing table's name. trying either store return value or state current cell not in table.

tia (this seems fundamental yet nowhere)

these return name of table of selected cell. if there no table run-time error thrown.

selection.listobject.name selection.listobject.displayname

you can avoid error using:

if not selection.listobject nothing     msgbox selection.listobject.name end if

?activesheet.listobjects(2) give name of second table on sheet , throw error if there no second table.


Comments

Post a Comment

Popular posts from this blog

javascript - Why Selenium can't find an element that is graphically visible -

-
i'm using selenium test appllication running on firefox browser, when want click on button selenium, don't find it. find strange since can see element eye. have tried multiple method worked other exemple : wait.until(expectedconditions.visibilityofelementlocated(by)) wait.until(expectedconditions.presenceofelementlocated(by)); (i use xpath in path variable, , i'm sure correct) setting implictlywait on driver putting thread.sleep(1000) then again, post here because don't understand why selenium not see element diplayed on browser. important information maybe giving me proper answer html dom dynamically generate websocket triggered javascript event. edit 1: <button type="button" class="btn btn-xs btn-block btn-stroke" id="252_button"> delete </button> the element i'm trying access. use xpath it. it's not in iframe element. to access element did method supposed find , click on giving xpath in para...
Read more

java - How to compare two classes -

-
i try create factory, here's code: public class myfactory { public static <t> mybase create(class<t> _c) { if (_c.getclass().equals(derived1.class)) // (1) return createnewderived1(); return null; } } // caller myfactory.create(derived1.class); it compiles warning @ line (1) : error 'equals()' between objects of inconvertible types 'class<derived1>' , 'class<capture of ? extends class>' <br>reports calls .equals() target , argument of incompatible types. while such call might theoretically useful, represents bug. and in runtime if statement fails reason. how can intended behaviour? public class myfactory { public static <t> mybase create(class<t> _c) { return ( _c == derived1.class ) ? createnewderived1() : null; } } // caller myfactory.create(derived1.class); see compare class objects further info. fiy, "real" class obje...
Read more

mysql - Gateway Timeout Error on Insert 70000 record using Hibernate in Java -

-
my problem is: upload 10000 record excel database. excel sheet has 10000 rows , 70 100 column . store value in 6 mapping table using hibernate cascade. call method using ajax method. due inserting large amount of data. return timeout error(502 (proxy error) or 504 (gateway error)). i using aws services. configuration mistake.. please help thanks in advance how might see 502 bad gateway error based on web server, might see different 502 error. these mean same thing, naming conventions differ. here few examples of might see: “502 bad gateway” “http error 502 – bad gateway” “502 service temporarily overloaded” “error 502” “502 proxy error” “http 502” “502 bad gateway nginx” can see in greater detail error entails going web server’s error log file. error / diagnostic information stored in file making valuable resource check when need more details particular error. can locate file in apache going /var/log/apache2/error.log , in nginx going /var/log/nginx/error.log. ...
Read more