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.
MS-Excel Expert
For Excel Training and Automated Tools, Please contact Vishesh Golya on visheshgolya@gmail.com or +91-98289-88829
Tuesday, January 19, 2016
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
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:
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:
- Go To Message on Your Phone
- TYPE MBAL.
- Send this message to 55333 ( toll-free)
- You will get a SMS with Reliance 2G/3G GSM data balance with it’s validity Soon.
Subscribe to:
Posts (Atom)