excel - Program code is deleting the data which I want to keep -

-

i have macro consolidate values on sheet, , based on these values, it´s has go on first sheet , delete. macro deleting want keep.

the sheet.

the macro: sub deleteothers()     dim r1 range, c range     dim t string      sheets("sheet2")         set r1 = .range(.cells(2, "h"), .cells(rows.count, "h").end(xlup))     end      each c in r1         if c.text = "<<<keep row"             sheets("sheet1").select             t = c.offset(0, -1)             rows(t).clearcontents         end if     next end sub

change to:

if c.text <> "<<<keep row"

Comments

Post a Comment

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

-
i searched on internet provided answers did not in building project. the error starting fork. tried following methods: mvn clean install -u when searched, people said because of java 7 , should work java 6. using java 6 only. some said set surefire plugin this: <groupid>org.apache.maven.plugins</groupid> <artifactid>maven-surefire-plugin</artifactid> <version>2.5</version> <configuration> <skiptests>false</skiptests> <testfailureignore>true</testfailureignore> <forkmode>once</forkmode> </configuration> the actual error is: [error] failed execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project junitcategorizer.instrument: error occurred in starting fork, check output in log -> [help 1] org.apache.maven.lifecycle.lifecycleexecutionexception: failed execute goal org.apache.maven.plugins:maven-surefire-plugin:2...
Read more

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

-
i fired windows 7 machine today , attempting start intemgr.exe process terminates immediately. started process under debugger. seems process terminating following exception: system.management.automation.cmdletinvocationexception . dumping exceptions on heap yields following results. heap has few more exception listed below. so based on research exception happens when cmdlet encounters terminating error. method call before processrecord(). provides record-by-record processing functionality cmdlet. windows powershell runtime calls method multiple times each instance of cmdlet in pipeline. how can inspect pipeline debugger? exception object: 0000000002702940 exception type: system.management.automation.itemnotfoundexception message: cannot find path 'c:\windows\system32\windowspowershell\v1.0\modules\applicationserver\applicationserver.dll' because not exist. innerexception: <none> stacktrace (generated): sp ip function 000000001...
Read more

unity3d - Fatal error- Monodevelop-Unity failed to start -

-
Image
i installed unity monodevelop seems not been installed tried open script in unity nothing come out, saying should find software opens when have set preferences monodevelop(built-in). then reinstalled again, time, contains visual studio too. can open visual studio. when tried open monodevelop, following pop-up apear. but have installed 2 things /net , gtk. shown below. problem? 1st time-- install gtk after install unity(no monodev) 2nd time-- install monodevelop unity went monodev website , says xamarin studio not monodevelop you messed in first step. you have uninstall gtk , else installed during time. includes unity too.if possible, system restore , set restore date time before installed of this. now, install unity, make sure monodevelop selected unity , install it. don't install gtk or other software. when using unity, monodevelop must installed unity , not other website. reason because using customized version of monodevelop .
Read more