Tuesday, October 27, 2020

OnePlus 8T Mobile Full Specifications - OnePlus 8T Mobile Price and Specifications

 OnePlus 8T Mobile Full Specifications - OnePlus 8T Mobile Price and Specifications

OnePlus 8T Price | OnePlus 8T Full Phone Specifications | OnePlus 8T Mobile Price and Specifications 

Execution 

Octa focus (2.84 GHz, Single Core + 2.42 GHz, Tri focus + 1.8 GHz, Quad focus) Snapdragon 865 

8 GB RAM 

Show 

6.55 inches (16.64 cm) 

402 PPI, Fluid AMOLED 

120 Hz Refresh Rate 

Camera 

48 + 16 + 5 + 2 MP Quad Primary Cameras 

Twofold LED Flash 

16 MP Front Camera 

Battery 

4500 mAh 

Turn Charging 

USB Type-C Port 

OnePlus 8T Price | OnePlus 8T Full Phone Specifications | OnePlus 8T Mobile Price and Specifications 

Include cOnePlus 8T Price | OnePlus 8T Full Phone Specifications | OnePlus 8T Mobile Price and Specifications 

OnePlus 8T Price | OnePlus 8T Full Phone Specifications | OnePlus 8T Mobile Price and Specifications 

OnePlus phones have rarely baffled us throughout late years. I was astonished by the lead OnePlus 8 Pro when it dispatched back in April, and it even transformed into my key phone for quite a while. However, for most OnePlus fans, the 8 Pro had a glaring issue: it was an unusually expensive contraption for the association, anyway maybe a crucial one to cover OnePlus unyieldingly extravagant creation and publicizing. 

In light of everything, the association in the end returned to its going through roots with the mid-range Nord three months afterward. While it offered a moreover smooth all in all knowledge, OnePlus cut corners with respect to execution and body materials. This shouldn't infer that the Nord was a horrendous phone; it was unimaginable at its expense, yet a couple of us for the most part long for an even more momentous wireless at a more sensible cost - 

This is the spot OnePlus' 8T comes in. It's essentially the OnePlus 8 with extra things - some of which arrange or even eclipse what the 8 Pro offered, in all honesty. In the US, you'll get the device with 12GB RAM and 256GB of the more current UFS 3.1 limit. That puts it legitimately between the OnePlus 8 and the 8 Pro with the identical config. Thusly, for an extra $50, you're getting a device that is more like a pioneer phone, yet still discernibly more affordable than the resistance. 

That being expressed, it's not the most great phone out there. The 8T really uses the Qualcomm's Snapdragon 865 processor and LPDDR4x RAM found in the OnePlus 8. Do whatever it takes not to stretch: this is totally fine for a large number individuals. You'd conceivably need the 865 Plus if you need that extra oomph for more uncommon gaming, and OnePlus RAM Boost seems to ensure fast stacking time for as a rule used applications, whether or not it's not using the more modern, faster LPDDR5 RAM. Concerning colors, there are only two other options: "greenish blue green" and "lunar silver." 

OnePlus similarly declares that its new covering method renders fingerprints more subtle through some optical cunning. In light of everything, it worked a piece, yet commonly exactly when I looked straight on. Not that it had any kind of effect an unnecessary add up to me, as I like to keep my phones in their cases. With my study test, OnePlus gave a "cyborg cyan" case and a cyan sandstone case, and I picked the past for its dorky clear equipment look. 

Incredibly, the OnePlus 8T got a critical redesign on the back, and I have mixed feelings about it. Since the time the OnePlus 6 up to the OnePlus 8 game plan, I like how the phones have kept the back cameras vertically changed along the center. This vital furthermore planning work, anyway I think it gave OnePlus phones a novel arrangement character when most PDAs have never been more samey.

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 

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.


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 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.

 

'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 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 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 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.

 

'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 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.

 

'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 

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 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 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 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 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 highlightUniqueValues()
Dim rng As Range
Set rng = Selection
rng.FormatConditions.Delete
Dim uv As UniqueValues
Set uv = rng.FormatConditions.AddUniqueValues
uv.DupeUnique = xlUnique
uv.Interior.Color = vbGreen
End Sub

Saturday, 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


Open Excel Sheet and Press Alt F11.
Go to insert menu and select new module.
in the new module paste the below code and save.

Sub deletehidden()
For lp = 256 To 1 Step -1
If Columns(lp).EntireColumn.Hidden = True Then Columns(lp).EntireColumn.Delete Else
Next
For lp = 65536 To 1 Step -1
If Rows(lp).EntireRow.Hidden = True Then Rows(lp).EntireRow.Delete Else
Next
End Sub

After saving the above code go the active excel sheet and select developer tab.
Click on Macros and select saved macro and click on run.

Now all the hidden rows in the filtered excel sheet will delete.

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 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 highlightUniqueValues()
Dim rng As Range
Set rng = Selection
rng.FormatConditions.Delete
Dim uv As UniqueValues
Set uv = rng.FormatConditions.AddUniqueValues
uv.DupeUnique = xlUnique
uv.Interior.Color = vbGreen
End Sub

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 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






Sub PasteVal()
    Selection.PasteSpecial Paste:=xlValues
End Sub


How to Paste Macro in Excel Module


Open Excel Sheet and Press Alt F11 Keys.

A New Window will Open and go to Insert Menu.

In Insert menu click on Module.

After inserting Module, a new window will open and copy and paste the above code in that window.

save the code after pasting in  the module.

Before this process, make excel sheet as Macro-Enabled Work Sheet.

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

To hide rows with zeros (0) in excel 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.

VBA Code to Hide Rows With Zeros


Sub HideRows()
Dim cell As Range
For Each cell In Range("J19:J33")
If Not isEmpty(cell) Then
If cell.Value = 0 Then 
cell.EntireRow.Hidden = True
End If
End If
Next
End Sub

Now easily 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

To Show Zeros (0) in Empty Cells, 

1. Open Excel Sheet and select the range of cells where you want to show Zeros (0) which is shown in below Figure 1.

How to Show Zeros (0) in Empty Cells in Excel | How to Display Zeros (0) in Blank Cells in Excel
2. After Selecting the Cells, Press Ctrl + F (find select). In find window click on replace and click in replace with and enter zero (0) and press replace all.(Shown in Fig2)

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
3. Now All the Blank Cells in the selected range are filled with Zeros (0). (Shown in Fig 3)
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 


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

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.

One Plus 8 Pro 5G Mobile Specifications | One Plus 8 Pro 5G Mobile Price | One Plus 8 Pro 5G




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...