Tuesday, October 27, 2020
OnePlus 8T Mobile Full Specifications - OnePlus 8T Mobile Price and Specifications
Tuesday, October 13, 2020
One Plus 8 Pro 5G Mobile Specifications | One Plus 8 Pro 5G Mobile Price | One Plus 8 Pro 5G
One Plus 8 Pro 5G Mobile Specifications | One Plus 8 Pro 5G Mobile Price | One Plus 8 Pro 5G
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.
Learn how to unmerge all merged cells in excel using macro | unmerge all merged cells in excel using macro
Learn how to unmerge all merged cells in excel using macro | unmerge all merged cells in excel using macro
Do the following steps using VBA Code.
1. Open active excel sheet7. Select Save as and again select Macro Enabled Worksheet and then save it.
'This code will unmerge all the merged cells
Sub UnmergeAllCells()
ActiveSheet.Cells.UnMerge
End Sub
Monday, October 12, 2020
Learn how to sort data by multiple columns in excel using macro | sort data by multiple columns in excel using macro
Learn how to sort data by multiple columns in excel using macro | sort data by multiple columns in excel using macro
Do the following steps using VBA Code.
1. Open active excel sheet7. Select Save as and again select Macro Enabled Worksheet and then save it.
Sub SortMultipleColumns()
With ActiveSheet.Sort
.SortFields.Add Key:=Range("A1"), Order:=xlAscending
.SortFields.Add Key:=Range("B1"), Order:=xlAscending
.SetRange Range("A1:C13")
.Header = xlYes
.Apply
End With
End Sub
Learn how to highlght blank cells using macro in excel | highlght blank cells using macro in excel
Learn how to highlght blank cells using macro in excel | highlght blank cells using macro in excel
Do the following steps using VBA Code.
1. Open active excel sheet7. Select Save as and again select Macro Enabled Worksheet and then save it.
'This code will highlight all the blank cells in the dataset
Sub HighlightBlankCells()
Dim Dataset as Range
Set Dataset = Selection
Dataset.SpecialCells(xlCellTypeBlanks).Interior.Color = vbRed
End Sub
Learn how to highlight all cells with comments in excel using macro | highlight all cells with comments in excel using macro
Learn how to highlight all cells with comments in excel using macro | highlight all cells with comments in excel using macro
Do the following steps using VBA Code.
1. Open active excel sheet7. Select Save as and again select Macro Enabled Worksheet and then save it.
'This code will highlight cells that have comments` Sub HighlightCellsWithComments() ActiveSheet.Cells.SpecialCells(xlCellTypeComments).Interior.Color = vbBlue End Sub
Sunday, October 11, 2020
Learn How to Add Header and Footer Date in Excel using Macro | Learn How to Add Header and Footer Date in Excel using Macro
Learn How to Add Header and Footer Date in Excel using Macro | Learn How to Add Header and Footer Date in Excel using Macro
Do the following steps using VBA Code.
1. Open active excel sheet Sub DateInHeader()
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = "&D"
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
End Sub
Learn How to Remove Text Wrap IN Excel using Macro | Learn How to Remove Text Wrap IN Excel using Macro
Learn How to Remove Text Wrap IN Excel using Macro | Learn How to Remove Text Wrap IN Excel using Macro
Do the following steps using VBA Code.
1. Open active excel sheet7. Select Save as and again select Macro Enabled Worksheet and then save it.
Sub RemoveTextWrap()
Range("A1").WrapText = False
End Sub
How to Insert Multiple Columns in Excel | Learn How to Insert Multiple Columns in Excel using Macro
Do the following steps using VBA Code.
1. Open active excel sheet
2. Press Alt + F11 and Visual Basic Application window will open.
3. Go to Insert Menu and select new Module.
4. In new Module insert the below VBA Code and save it.
5. Before do the above process, excel sheet must save as Macro-Enabled.
6. To do Macro Enabled, open Excel Sheet and Click on the Office Button which is at left top corner on excel sheet.
7. Select Save as and again select Macro Enabled Worksheet and then save it.
Sub InsertMultipleColumns()
Dim i As Integer
Dim j As Integer
ActiveCell.EntireColumn.Select
On Error GoTo Last
i = InputBox("Enter number of columns to insert", "Insert Columns")
For j = 1 To i
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromRightorAbove
Next j
Last: Exit Sub
End Sub
Excel Tricks : VBA Code to find Unique Values in excel | Macro to highlight unique values in excel
Excel Tricks : VBA Code to find Unique Values in excel | Macro to highlight unique values in excel
To highligh unique values in excel do the following steps using VBA Code.
1. Open active excel sheetSaturday, October 10, 2020
How to delete hidden rows after filter in excel using VBA Code | How to delete hidden rows after filter in excel using VBA Macro
How to delete hidden rows after filter in excel using VBA Code | How to delete hidden rows after filter in excel using VBA Macro
VBA Code
Excel Tricks : VBA Code to find Unique Values in excel | Macro to highlight unique values in excel
Excel Tricks : VBA Code to find Unique Values in excel | Macro to highlight unique values in excel
To highligh unique values in excel do the following steps using VBA Code.
1. Open active excel sheetHow to Create a Shortcut Key to Paste Special Values in Excel | VBA Code to Paste Special Values in Excel | Macro to Paste Special Values in Excel
How to Create a Shortcut Key to Paste Special Values in Excel | VBA Code to Paste Special Values in Excel | Macro to Paste Special Values in Excel
How to Create a Shortcut Key to Paste Special Values in Excel | VBA Code to Paste Special Values in Excel | Macro to Paste Special Values in Excel
How to Paste Macro in Excel Module
Macro to hide rows with number zeros in Excel | VBA Code to hide rows with number zeros in Excel
Macro to hide rows with number zeros in Excel | VBA Code to hide rows with number zeros in Excel
VBA Code to Hide Rows With Zeros
How to Show Zeros (0) in Empty Cells in Excel | How to Display Zeros (0) in Blank Cells in Excel
How to Show Zeros (0) in Empty Cells in Excel | How to Display Zeros (0) in Blank Cells in Excel
| How to Show Zeros (0) in Empty Cells in Excel | How to Display Zeros (0) in Blank Cells in Excel |
| How to Show Zeros (0) in Empty Cells in Excel | How to Display Zeros (0) in Blank Cells in Excel |
Wednesday, October 7, 2020
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
One Plus 8 Pro 5G Mobile Specifications | One Plus 8 Pro 5G Mobile Price | One Plus 8 Pro 5G
One Plus 8 Pro 5G Mobile Specifications | One Plus 8 Pro 5G Mobile Price | One Plus 8 Pro 5G
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.
Lion King 2019 Telugu Movie | Lion King Telugu Movie | Lion King Telugu Version Movie
Lion King 2019 Telugu Version Movie has been released and running successfully in theaters. Telugu Top Heros J agapathi Babu and Nani g...
