Art of Excel

We are happy to come back to your service again. Reachout for Advanced as well basic cources on the Art of Excel

What is the output of this following code if: -

1) Cell A1 has "Art of Excel" written in it
2) Cell A1 has 12345 written in it
3) Cell A1 has "12345" written in it and
4) Cell A1 is blank

Comment your answer.
********************************************************************************************

Private Sub errMsg(err_text As String)
MsgBox "Error : " & err_text & " !"
End Sub

Sub test1()
If Range("A1") = "" Then
errMsg "empty cell"
ElseIf Not IsNumeric(Range("A1")) Then
errMsg "non-numerical value"
End If
End Sub

What is the correct way to declare a 2D string type dynamic array in VBA?? Comment your answer.

a) Dim arr2D()() As String
b) Dim arr2D( , ) As String
c) Dim arr2D() As String
d) Dim arr2D(5,5) As String

Call today to join next batch +91-7042141938

Setting Alignment for Cell Content:

You can align data in a spreadsheet cell with these two properties - HorizontalAlignment and VerticalAlignment. These properties can be used with ActiveCell, Range or Cells. The valid values for HorizontalAlignment are as follow:

xlCenter
xlLeft
xlRight

For VerticalAlignment the valid value are:

xlBottom
xlCenter
xlTop

Have a look at the following code examples to understand how it works.

ActiveCell.HorizontalAlignment = xlCenter

ActiveCell.HorizontalAlignment = xlRight

ActiveCell.VerticalAlignment = xlBottom

We have new presence on web - www.artofxl.blogspot.in . Please keep visiting it for new tips and tricks. We will be publishing articles there which will really help you in becoming an expert in excel

Question from member - Vishal

Sub ifcondition()
Dim a As Integer
a = InputBox("Enter a no between 1to7")
If a = 1 Then
MsgBox ("monday")
If a = 2 Then
MsgBox ("Tuesday")
If a = 3 Then
MsgBox ("Wednesday")
If a = 4 Then
MsgBox ("Thursday")
If a = 5 Then
MsgBox ("Friday")
If a = 6 Then
MsgBox ("Saturday")
If a = 7 Then
MsgBox ("Sunday")
Else
MsgBox ("Holiday")
End If
End Sub
I'm getting an error blockif without Endif

How many of you are able to spot the problem?

What do you do when you have to create an excel document from scratch with lot of data ?
1) Look for a template on net
2) Look for template in excel
3) Ask some friend to help out
4) Code Macro to design a template

Join us to become master of Excel Macros and VBA Programming

How many Strings can be concatenated together in excel in one formula?

In how many ways can you get the sum of squares of numbers between B3 to B9?? You can write your formula in the cell E6 only.

Question for all Excel Lovers :
What is the difference between command "Find" and "Search"?