Get range of active object (image) in excel/VBA -

-

i know incredibly simple, can't seem figure out or find answer elsewhere. ill want range of selected image. in advance help.

here sample how top-left , botton-right cells of picture on excel sheet. picture has selected.

sub test()     if (vba.typename(selection) = "picture")         dim pic excel.picture         set pic = selection          dim topleft range         set topleft = pic.topleftcell         debug.print topleft.address          dim bottomright range         set bottomright = pic.bottomrightcell         debug.print bottomright.address     end if end sub

Comments

Post a Comment

Popular posts from this blog

pentaho - Carte Status / Kettle Slave Server Status page shows status for random runs instead of the latest run -

-
i trying programmatically details of specific execution of transformation what have tried far i status of kettle slave server/carte @ http://localhost:8282/kettle/status/ from page, can click on desired transformation , taken page shows details , has link xml output current status of specific execution of transformation. link this: http://localhost:8282/kettle/transstatus/?name=trans_name&id=carte_ob_id&xml=y the problem i have transformation has been run multiple times recently. don't have carte_obj_id specific run of transformation. so, can't provide in uri. if try following uri instead: http://localhost:8282/kettle/transstatus/?name=trans_name&xml=y then status of random execution. not latest 1 or specific one. the goal i writing .net gui have code. httpwebrequest req = (httpwebrequest)webrequest. create(@"http://localhost:8282/kettle/transstatus/? name=trans_name ...
Read more

c - sscanf() double showing zeros -

-
i'm having troubles sscanf() function read doubles. have comma separated text file this: abc,def,0.465798,0.754314 ghi,jkl,0.784613,0.135264 mno,opq,0.489614,0.745812 etc. so first line fgets() , use sscanf() 2 string , 2 double variables. fgets(buffer, 28, file); sscanf(buffer, "%4[^,],%4[^,],%lf[^,],%lf[^\n]", string1, string2, &double1, &double2); printf("%s %s %f %f\n", string1, string2, double1, double2); but output is: abc def 0.465798 0.000000 ghi jkl 0.784613 0.000000 mno opq 0.489614 0.000000 so somehow doesn't scan last float. i've tried %lf[^ \t\n\r\v\f,] , %lf still doesn't work. change "%4[^,],%4[^,],%lf[^,],%lf[^\n]" to int result; result = sscanf(buffer, "%4[^,],%4[^,],%lf,%lf", string1, string2, &double1, &double2); if (result != 4) // handle error notice & on double1 , double2 - likley typo. also strongly recommend check result 4. not checking sscanf(...
Read more