Question
What is the difference between usedrange and currentregion properties ?
Answers
The current region is a range bounded by any combination of blank rows and blank columns.
This property is useful for many operations that automatically expand the selection to include the entire current region, such as the AutoFormat method. This property cannot be used on a protected worksheet.
The UsedRange property is used to select the range of used cells on a worksheet. It returns a Range object that represents the used range on the specified worksheet.
Every non-blank cell got its CurrentRegion and its keyboard shortcut is Ctrl+Shift+Spacebar.
There can be many current regions but there is only one used range in a worksheet.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Mention the type of fruit in Lepicoleaceae Family?
  • Q What is the function of partprobe?
  • Q Explain system.runas()?
  • Q After replacing the NIC card of a PC on the LAN, your Cisco switch shows a new MAC address is attached to that port. Which of the following answer choices below correctly describe a MAC address? (Select all that apply) A. It is a globally unique IP address. B. It is a globally unique 48 bit address C. It is provided by the manufacturer of the NIC. D. It is used as part of the IPX/SPX configuration. E. It is a logical address.
  • Q To which group of artists does Vincent Van Gough belong
  • Q Please share with us your philosophy about customer service in an academic environment.
  • Q How do the three kinds of learning that occur during socialization differ in their impact on the ease with which different customs may change?
  • Q A person agreed to marry his daughter to me, but later on changed his mind because of the mischievous things told to him by someone else. If I commit sins then who is responsible for those sins - the one who played the mischief or the man who changed his mind to marry his daughter to me? Is that man who broke the agreement of marriage also a sinner?
  • Q Assistive Media of Ann Arbor, Michigan was the first organization to produce and deliver spoken word recordings of written journalistic and literary works via the Internet to serve people with
  • Q Who was the author of Gita Govinda?
  • Q Who sent 'Chaverpada' to Mamankom?