Facing Error while applying excel formula in Macro -

-

i have below type of values in column j in excel 

<a href="http://twitter.com" rel="nofollow">twitter web client</a>

and, have used formula 

=right(left(j2,len(j2)-4),len(left(j2,len(j2)-4))find(">",left(j2,len(j2)-4),2))

to value "twitter web client.

when tried apply macro using below code in not getting value. me in code applying formula in entire range of 'q' column referencing 'j' column

sub enter_formula()      range("q2").formula = "=right(left(j2,len(j2)-4),len(left(j2,len(j2)-4))-find(" > ",left(j2,len(j2)-4),2))"  end sub

you try this

lastrow = activesheet.usedrange.rows.count msgbox lastrow 'this give user range value used enter formulaa in rows range("q2:q" & lastrow).formula = "=left(right(rc[-7],len(rc[-7])-find("">"",rc[-7],2)),len(right(rc[-7],len(rc[-7])-find("">"",rc[-7],2)))-4)"

the result set "twitter web client" text.


Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more