Tuesday, January 19, 2016

How to Resize the bulk images in Photoshop

Many times we require to resize the images in bulk. Manually it is possible but it takes too long when it comes to hundreds or thousands of images in a specific size. Now here is the solution of your problem. Click Here to learn how you can Resize the number of images easily in photoshop.

Monday, January 18, 2016

Transpose the Bulk address data using the Macro or VBA code

Transpose the Bulk address data using the Macro or VBA code:

Query is mentioned in the below image:

Solution:

Sub TransposeColToRow()
Dim LastRow As Integer
Dim j As Integer
Dim SaveJ As Integer
Dim Myvalue As String
Dim CurrValue
LastRow = Range(“A65536”).End(xlUp).Row
k = 0
l = 0
For j = 1 To LastRow
If Range(“A” & j).Value “” Then
Range(“D1”).Offset(k, l).Value = Range(“A” & j).Value
l = l + 1
Else
l = 0
k = k + 1
End If
Next j
End Sub

Thursday, January 14, 2016

How to check 2G/3G Data/Internet Balance in Reliance GSM

Check 2G/3G Data/Internet Balance and Validity in Reliance GSM Prepaid:

Dial *111*1*3#

If above code is not working then Dial *111# and reply 1 and 3 respectively.

OR

Check Data Balance in Reliance GSM with SMS:
  1.     Go To Message on Your Phone
  2.     TYPE  MBAL.
  3.     Send this message to  55333 ( toll-free)
  4.     You will get a SMS with  Reliance 2G/3G GSM data balance with it’s validity Soon.