excel - How to select range cell with VBA and align to top instead to the middle of the window? -

-

i created hiperlink, not working correctly. when vba executed, selected cell in middle of window, want align selected cell top left in window resolution. navigation on document. excel 2010.

add following line of code after make cell hyperlink:

application.goto cells(1,1),true

replace cells(1,1) appropriate cell.


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