excel - Concatenate formula with rowcount -

-

i trying enter concatenate formula in cell vba. result writes keep returning false... need use rowcount, since table grows longer , need row.

this latest code tried, again no avail:

.offset(rowcount, 0) = formula = "=concatenate(p" & rowcount & "j" & rowcount & "dg" & rowcount

any suggestions appreciated.

you're not creating string , need change = formula = .formula =. also, i'm assuming rowcount defined somewhere?

change:

.offset(rowcount, 0) = formula = "=concatenate(p" & rowcount & "j" & rowcount & "dg" & rowcount

to:

.offset(rowcount, 0).formula = "=concatenate(p" & rowcount & ",j" & rowcount & ",dg" & rowcount & ")"

Comments

Post a Comment

Popular posts from this blog

angular ui router - 10 digest iterations reached in angularjs when using $state.go -

-
i using angular ionic. i not want user have login again in case logged in , did not logout last time used application. reason, using local storage check if user logged in. tried putting code in run block. $rootscope.$on('$statechangestart', function (event, tostate, toparams, fromstate, fromparams) { if($localstorage.userinfo){ $state.go('deployment'); //this line 270 of app.js event.preventdefault(); return; } }) but gives error says: rangeerror: maximum call stack size exceeded @ scope.$broadcast (ionic.bundle.js:23414) @ object.transitionto (ionic.bundle.js:40804) @ object.go (ionic.bundle.js:40671) @ app.js:270 @ scope.$broadcast (ionic.bundle.js:23412) @ object.transitionto (ionic.bundle.js:40804) @ object.go (ionic.bundle.js:40671) @ app.js:270 @ scope.$broadcast (ionic.bundle.js:23412) @ object.transitionto (ionic.bundle.js:40804) also, error: [$rootscope...
Read more

symfony - InvalidConfigurationException in SecurityExtension.php line 429: No authentication listener registered for firewall "secured_area" -

-
i'm new symfony user , follow tutorial . current task add logout script unfortunately gives me error: invalidconfigurationexception in securityextension.php line 429: no authentication listener registered firewall "secured_area". my security.yml file looks this: security: # http://symfony.com/doc/current/book/security.html#where-do-users-come-from-user-providers providers: in_memory: memory: users: ryan: password: $2a$12$lcy0mefviec3typhv9snnuzofyr2p/axigoqjeds4am4jwhnz/jli roles: 'role_user' admin: password: $2a$12$cytwee9kpq1pjqkfiwuzfucrpwvyazwm4xzmz1qpufl7/flcm3v0g roles: 'role_admin' firewalls: secured_area: # ... logout: path: /logout target: / # disables authentication assets , prof...
Read more

javascript - Can Piwik report referrer in real time? -

-
i looking query piwik api in real-time stats on current visitor. example, have javascript file that'd i'd fetch piwik api json info on visitor using page contains javascript file (referrer, mobile/desktop, location etc.) as far understand piwik must have data generate analytics on per-user basis. fear might not allow querying info in way i've described above. if that's case, can obtain pw? api method better, if not i'd use same system make real-time reports 1 use generate stats on groups of users particular 1 belongs to. according api page , piwik live! widget refreshes every 5 seconds, , displays new visits. each visitor, can see: date number of actions time spent on site country browser operating system whether visitor new or returning visit the referrer used access site (search engine & keyword, campaign, or referrer website) whether visitor converted goal you can query live! api module , use live.getlastvisitsdetails method ...
Read more