Grouping and ungrouping a specified range with excel VBA -


i have range of cells (a60 y70) . group , ungroup columns of these cells way broad , complexed view. possible ungroup , group specified range use of vba. there many more ranges of such function useful me! thank you:)

you can use group function:

range("a60", "y70").group

or ungroup them:

range("a60", "y70").ungroup

-

Comments

Post a Comment

Popular posts from this blog

java - OnDragListener Fires Several Times? -

i have several layouts; each containing textview . if user drags textview unto textview , i'm going execute method swapfamily() it fires several times, depending on number of families . familyitemlayout custom linearlayout string attribute attached , add'tl getters , setter attribute. however, issue that, private class ondropfamily implements view.ondraglistener { @override public boolean ondrag(view view, dragevent event) { textview txtdragged = (textview) event.getlocalstate(); textview txttarget = (textview) view; string familydragged = ((familyitemlayout) txtdragged.getparent()).getfamily(); string familytarget = ((familyitemlayout) txttarget.getparent()).getfamily(); switch (event.getaction()) { // signals start of drag , drop operation. case dragevent.action_drag_started: break; // signals view drag point has entered bounding box of view. case ...
Read more

spring - "Dispatcher has no subscribers" during startup -

i facing problem happens , hard reproduce. therefore have problems creating compelling test case. our setup looks this: spring integration spring boot rabbitmq listener custom bus manages transaction aware messages the setup not newest anymore , lot of code replaced more idiomatic spring wiring. though exception getting when service started: dispatcher has no subscribers, failedmessage=genericmessage [payload=com.foobar.service.greencheckout.message.greenorderpropertyaddedmessage@2ba0efb2, headers={id=f750a792-6b01-16d3-8206-6e553a03f8fa, type=com.foobar.service.greencheckout.message.greenorderpropertyaddedmessage, amqp_deliverymode=persistent, timestamp=1505797680967}], failedmessage=genericmessage [payload=com.foobar.service.greencheckout.message.greenorderpropertyaddedmessage@2ba0efb2, headers={id=f750a792-6b01-16d3-8206-6e553a03f8fa, type=com.foobar.service.greencheckout.message.greenorderpropertyaddedmessage, amqp_deliverymode=persistent, timestamp=1505797680967...
Read more

c# - ajax - How to receive data both html and json from server? -

i have referenced this topic , doesn't solve problem. i'm using mvc 5 c#. have used code receive data server data type json . $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "json", success: function (data) { if (data.result) { alert('successfull'); } else { alert(data.ex); } } }); and controller code: [httppost] public actionresult myaction() { try { return json(new { result = "true", ex = "" }); } catch (exception e) { return json(new { result = "false", ex = e.message }); } } i use way data type html: $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "html", success: function (data) { $(".mydiv").append(data); } }); and controller should be: [httppost] public actionresult myaction() { return partialview("_...
Read more