One Plus 8 Pro 5G Mobile Specifications | One Plus 8 Pro 5G Mobile Price | One Plus 8 Pro 5G (Onyx Black 12GB RAM+256GB Storage)

Starting with announcement of these cellphone  Oneplus 8 and one plus 8 pro announce in April 13 2020  next is network technology, one plus 8 pro and one plus 8 having GSM / CDMA / HSPA / LTE / 5G. Display size of Oneplus 8 pro slightly bigger. 

Weight of oneplus 8 pro with 199 grams then lastly One plus 8 with 160.2 grams.All are build with same Glass front (Gorilla Glass 5), glass back, aluminum frame.

The major thing that bring very interesting point is IP68 dust/water resistant certificate if mobile drops in to the water then using this certificate they can get much advantages for the user.This is not available for the remaining mobiles.

Display wise Fluid AMOLED capacitive touchscreen, 1Billion  colors are supported by oneplus 8 pro. Oneplus8 supports Fluid AMOLED capacitive touchscreen, 16M colors.Even the refresh rate is 120Hz for oneplus 8 and supports for 90 HZ.

One Plus 8 and One Plus 8 Pro are having same Qualcomm SM8250 Snapdragon 865 chipset and Adreno 650 GPU and having Android 10, OxygenOS 10.0 operating system.

Oneplus 8 pro bit lower in oneplus8 where as battery aslo is very good as Non-removable Li-Po 4780 mAh.  

Camera of Oneplus 8 pro leads with extra feature of  telephone camera also it  has 48 mp regular camera with 48mp wide ,48mp macro  and 5mp depth sensor.

One Plus 8 Pro 5G (Onyx Black 12GB RAM+256GB Storage)

One Plus 8 Pro 5G Mobile Specifications | One Plus 8 Pro 5G Mobile Price | One Plus 8 Pro 5G (Onyx Black 12GB RAM+256GB Storage)

One Plus 8 Pro 5G Onyx Black Price (12+256 GB) = 59,999

One Plus 8 Pro 5G Ultramarine Blue (12+256 GB) = 59,999

One Plus 8 Pro 5G Glacial Green (12+256 GB) = 59,999

Whistle Telugu Movie 2019 | Vijay Whistle 2019 Telugu Movie Cast & Crew | Whistle 2019 Telugu Movie

Whistle Telugu Movie 2019 | Vijay Whistle 2019 Telugu Movie Cast & Crew | Whistle 2019 Telugu Movie

Tamil Star Vijay Whistle Telugu Movie is going to release on 25th October 2019. This Whistle Movie is dubbed Movie of Tamil Movie Bigil. Whistle Movie is directed by Atlee. Nayanatara is paried up with hero Vjay. Many Other Lead actors acted in this Whistle Movie. AR Rahman composed music for this Whistle Movie.

Whistle Telugu Movie 2019 | Vijay Whistle 2019 Telugu Movie Cast & Crew | Whistle 2019 Telugu Movie

Vijay

Nayanatara

Kathir

Vivek

Anand Raj

Atlee      :   Director

AR Rahman:     Music Director

Redmi Note 7 Mobile Specifications | Redmi Note 7 Mobile

Redmi Note 7 Mobile Specifications | Redme Note 7 Mobile 

Redmi Note 7 Specifications :

OS                                                       Android Pie v9.0

Item model number                         Redmi 7

Form factor                                       Touchscreen Phone

RAM                                                     3 GB

Batteries:                                          1 Lithium ion batteries required. (Included)

Battery Power Rating                      4000

Wireless technologies                      Bluetooth, WiFi Hotspot

Connectivity technologies               GPS/AGPS, GLONASS, BeiDou, Micro USB 2.0 OTG, IR  blaster, Bluetooth v5.0 wireless technology, Wi-Fi, 802.11 b/g/n

Special features                                 Dual SIM, GPS, Music Player, Video Player, Infrared, Proximity, Accelerometer, Ambient light sensor, e-Compass

Display technology                           269 ppi pixel density

Other camera features                      2MP

Redme Note 7 Mobile Specifications | Redme Note 7 Mobile 

Redmi Note 7 Mobile Specifications | Redme Note 7 Mobile 

New Zealand vs England World Cup Final Match 2019 | New Zealand vs England World Cup Final Match 2019

New Zealand vs England World Cup Final Match 2019 | New Zealand vs England World Cup Final Match 2019 

World Cup 2019 Final to be played by New Zealand and England. Both the teams never won a world cup. Both the teams are in very much confident about World Cup Final Match 2019. World Cup 2019 will be played on Sunday at Lords. New Zealand has beaten India in semifinals and England beat Australia in Semifinal. New Zealand captain Kane Williamson is very much confident about his team and England captain Morgan is confident about his team as well. 

New Zealand vs England World Cup Final Match 2019 | New Zealand vs England World Cup Final Match 2019 

New Zealand vs England World Cup Final Match 2019 | New Zealand vs England World Cup Final Match 2019

India vs Srilanka 2019 World Cup Match Live Score | Srilanka vs India 2019 World Cup Match Live Score

India vs Srilanka 2019 World Cup Match Live Score | Srilanka vs India 2019 World Cup Match Live Score 

World Cup 2019: India vs Srilanka Match to be held on 06.07.2019 at Leads. India already went to the Semi-Finals for the World Cup 2019. Srilanka wants to end up the World Cup Tournament with Win against India. Srilanka did not go to the Semi-Finals. Indian Captain Virat Kohli is very much confident about his team after winning against Bangladesh. Srilanka Team Captain even much confident about his team. 

India vs Srilanka 2019 World Cup Match Live Score | Srilanka vs India 2019 World Cup Match Live Score 

India vs Srilanka 2019 World Cup Match Live Score | Srilanka vs India 2019 World Cup Match Live Score 

Macro to highlight alternate cells in excel | VBA to highlight alternate cells in excel

Macro to highlight alternate cells in excel | VBA to highlight alternate cells in excel 

Open Excel Sheet

Press Alt + F11 Key 

Go to the Insert Menu and Click on new Module

in New Module copy and paste the above VBA code and save.

Now Press Alt + F8  and new windows will open which is shown in below figure,

in that windows, you will ask to enter a key to create a shortcut for Paste Special

Enter a letter in the box. 

Macro to highlight alternate cells in excel | VBA to highlight alternate cells in excel 

Sub HighlightAlternateRows()

Dim Myrange As Range

Dim Myrow As Range

Set Myrange = Selection

For Each Myrow In Myrange.Rows

   If Myrow.Row Mod 2 = 1 Then

      Myrow.Interior.Color = vbCyan

   End If

Next Myrow

End Sub

Macro to Highlight Blank Cells in Excel | VBA Code to Highlight Blank Cells in Excel

Macro to Highlight Blank Cells in Excel | VBA Code to Highlight Blank Cells in Excel

Open Excel Sheet

Press Alt + F11 Key 

Go to the Insert Menu and Click on new Module

in New Module copy and paste the above VBA code and save.

Now Press Alt + F8  and new windows will open which is shown in below figure,

in that windows you will ask to enter a key to create a shortcut for Paste Special

Enter a letter in the box.

 Macro to Highlight Blank Cells in Excel | VBA Code to Highlight Blank Cells in Excel

Sub HighlightBlankCells()

Dim Dataset as Range

Set Dataset = Selection

Dataset.SpecialCells(xlCellTypeBlanks).Interior.Color = vbRed

End Sub

Macro to insert multiple rows | VBA Code to insert multiple rows

Macro to insert multiple rows | VBA Code to insert 

multiple rows

Open Excel Sheet
Press Alt + F11 Key 
Go to the Insert Menu and Click on new Module
in New Module copy and paste the above VBA code and save.
Now Press Alt + F8  and new windows will open which is shown in below figure,
in that windows you will ask to enter a key to create shortcut for Paste Special
Enter a letter in the box. 

Macro to insert multiple rows | VBA Code to insert multiple rows

Sub InsertMultipleRows()

Dim i As Integer
Dim j As Integer
ActiveCell.EntireRow.Select
On Error GoTo Last
i = InputBox("Enter number of columns to insert", "Insert
Columns")
For j = 1 To i
Selection.Insert Shift:=xlToDown,
CopyOrigin:=xlFormatFromRightorAbove
Next j
Last:Exit Sub
End Sub

How to Convert all Formlas into Values in Excel

How to Convert all Formulas into Values in Excel 

Sub ConvertToValues()
With ActiveSheet.UsedRange
.Value = .Value
End With

End Sub


Open Excel Sheet

Press Alt + F11 Key 

Go to the Insert Menu and Click on new Module

in New Module copy and paste the above VBA code and save.

VBA Code to How to Sort Data by Single Column

Open Excel Sheet

Press Alt + F11 Key 

Go to the Insert Menu and Click on new Module

in New Module copy and paste the above VBA code and save.

Now Press Alt + F8  and new windows will open which is shown in below figure,

in that windows you will ask to enter a key to create shortcut for Paste Special

Enter a letter in the box. 

Sub SortDataHeader()
Range("DataRange").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes
End Sub

VBA Code to Highlight Blank Cells With VBA

Open Excel Sheet

Press Alt + F11 Key 

Go to the Insert Menu and Click on new Module

in New Module copy and paste the above VBA code and save.

Now Press Alt + F8  and new windows will open which is shown in below figure,

in that windows you will ask to enter a key to create shortcut for Paste Special

Enter a letter in the box. 


Sub HighlightBlankCells()
Dim Dataset as Range
Set Dataset = Selection
Dataset.SpecialCells(xlCellTypeBlanks).Interior.Color = vbRed

End Sub

VBA Macro to Highlight All Cells With Comments

Open Excel Sheet

Press Alt + F11 Key 

Go to the Insert Menu and Click on new Module

in New Module copy and paste the above VBA code and save.

Now Press Alt + F8  and new windows will open which is shown in below figure,

in that windows you will ask to enter a key to create shortcut for Paste Special

Enter a letter in the box. 


Sub HighlightCellsWithComments()
ActiveSheet.Cells.SpecialCells(xlCellTypeComments).Interior.Color = vbBlue

End Sub

VBA Code to Refresh All Pivot Tables in the Workbook

Open Excel Sheet

Press Alt + F11 Key 

Go to the Insert Menu and Click on new Module

in New Module copy and paste the above VBA code and save.

Now Press Alt + F8  and new windows will open which is shown in below figure,

in that windows you will ask to enter a key to create shortcut for Paste Special

Enter a letter in the box. 




Sub RefreshAllPivotTables()
Dim PT As PivotTable
For Each PT In ActiveSheet.PivotTables
PT.RefreshTable
Next PT
End Sub