GooglyTechno: July 2019

Tuesday, July 23, 2019

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

Redmi Note 7 Mobile Specifications | Redmi Note 7 Mobile

Redme Note 7 Mobile Specifications | Redme Note 7 Mobile

Redmi Note 7 Mobile Specifications | Redme Note 7 Mobile

Friday, July 12, 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

Saturday, July 6, 2019

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

Monday, July 1, 2019

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

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