VBA Excel Get the count of rows and columns

' Used Range for sheet1 as an example
MsgBox Sheet1.UsedRange.Rows.Count
MsgBox Sheet1.UsedRange.Columns.Count


' Used Range for a specific sheet
MsgBox Sheets("Customers").UsedRange.Rows.Count
MsgBox Sheets("Customers").UsedRange.Columns.Count

VBA Excel Populate date and time in excel cell

'Populate Date and time in Date field G8
Sheets("sheet1").Range("A1") = Format(Now, "dd-mm-yyyy hh:mm")



How is meta tag used in a HTML page

 
 
<meta http-equiv="X-UA-Compatible" content="IE=10">
 
 <meta http-equiv="refresh" content="30">
<meta name="generator" content="Oracle UIX"> 
<meta name="viewport" content="width=device-width,initial-scale=1.0">
 
Use the name attribute to define a description, keywords, and the author of an HTML document.
 
 <meta name="value"> 
 
Attribute Values:
 
 application-name
author
<head>
  <meta name="description" content="Free Web tutorials">
  <meta name="keywords" content="HTML,CSS,JavaScript">
  <meta name="author" content="John Doe">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
</head> 
 
 
 
 The http-equiv attribute provides an HTTP header for the information/value of the content attribute.
 
<head>
  <meta http-equiv="refresh" content="30">
</head>
 
Note: If the http-equiv attribute is set, the name attribute should not be set. 
 
HTML5 introduced a method to let web designers take control over the viewport (the user's visible area of a web page), through the <meta> tag  
 
<meta name="viewport" content="width=device-width, initial-scale=1.0"> 
 
The width=device-width part sets the width of the page to follow the screen-width of the device (which will vary depending on the device).
The initial-scale=1.0 part sets the initial zoom level when the page is first loaded by the browser.

 
 

How is DOCTYPE and DTD used in a HTML page?

 
<!DOCTYPE html>
 
The <!DOCTYPE> declaration is not an HTML tag
 
The DTD specifies the rules for the markup language, so that the browsers render the content correctly. 
 Tip: Always add the <!DOCTYPE> declaration to your HTML documents, so that the browser knows what type of document to expect.

HTML 4.01 Strict

This DTD contains all HTML elements and attributes, but does NOT INCLUDE presentational or deprecated elements (like font). Framesets are not allowed.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
 
 

HTML 4.01 Transitional

This DTD contains all HTML elements and attributes, INCLUDING presentational and deprecated elements (like font). Framesets are not allowed.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
FAQ : What is DTD?
 
A DTD defines the structure and the legal elements and attributes of an XML document.
With a DTD, independent groups of people can agree on a standard DTD for interchanging data.
An application can use a DTD to verify that XML data is valid.

<!DOCTYPE note SYSTEM "note.dtd">
<note>
  <to>Tove</to>
  <from>Jani</from>
  <heading>Reminder</heading>
  <body>Don't forget me this weekend!</body>
</note>


Seen from a DTD point of view, all XML documents are made up by the following building blocks:
  • Elements
  • Attributes
  • Entities
  • PCDATA
  • CDATA
  

Elements

Elements are the main building blocks of both XML and HTML documents.
Examples of HTML elements are "body" and "table".
Examples of XML elements could be "note" and "message".

<body>some text</body>
<message>some text</message>

Entities

Some characters have a special meaning in XML, like the less than sign (<) that defines the start of an XML tag.

PCDATA

PCDATA means parsed character data.
Think of character data as the text found between the start tag and the end tag of an XML element.

 

CDATA

CDATA means character data.
CDATA is text that will NOT be parsed by a parser. Tags inside the text will NOT be treated as markup and entities will not be expanded.

 

Analytics