Select Non Blank cells of ActiveSheet

If you want to replace or select non-blank cells on the particular columns in active sheet, use the below codes: 

  Input: I have selected Non blank cells on the Active Sheet and replaced with 1. Result:

Samsung SmartTV-YouTube App-Blackscreen

Quick fix for the samsung smartTV -Youtube App / NetFlix App – Black screen problem. Please watch the below video . Hope it helps. Please leave your comments below.

Google Pixel Phones

The first phone made by Google – PIXEL.   This time, Google has manufactured his own hardware and released two phones namely PIXEL and PIXEL XL . The interesting thing is it comes with VR headset ( Virtual Reality). Differentiated primarily by the size and resolution of their screens — 5-inch 1080p display on the …

Continue reading

Google Allo-Competitor for Whatsapp?

Google launched a new one this week called Allo. Google actually unveiled Allo (a messaging app) and Duo (a video calling app) at Google I/O in May, but just hours ago, Allo finally made its way to the App Store on iOS and Google Play on Android. “What’s the big deal?” you might ask. Google …

Continue reading

SharePoint CSOM- Turn off the formatted XML View

CSOM SharePoint View

Tools> Internet options> Content >Feed settings > Un check Feed reading view     Note: You have to close the browser and start it again

INDEX – MATCH Formula’s Combination

INDEX – MATCH Formula’s Combination VLookup – Searching a value in the left-most column of table array and return value based on column index number.   Combined INDEX MATCH –   formulas work as a right to left lookup, whereas VLOOKUP only works left to right. We can use INDEX MATCH to lookup a value that is …

Continue reading

VBA – Turn off Auto Filter

Turn off Auto Filter in Active sheet   If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False     Turn off Auto Filter in Table   If Sheet1.ListObjects(“Table1”).ShowAutoFilter = True Then              Sheet1.ListObjects(“Table1”).ShowAutoFilter = False      End If

Excel 2013 very slow

Affected users: Global Problem:  Excel 2013 is very slow When I copy and paste some data Excel is crashing and taking long time Excel performance is really slow if I filter any data on the cell Solution:- Task 1: Increase your virtual memory Open the control panel > on the right hand top corner >Select …

Continue reading

“Cannot insert object” error in an ActiveX -Security Patch Issue

Affected Users: Global Problem:    You will get one of the Error in Excel   Object library invalid or contains references to object definitions that could not be found. Cannot insert object. Solution:-1   Please check your system whether you have Admin rights.  if not through following steps   Step1: Click the bottom of the right …

Continue reading

Sharon Fruit

I had the best fruit in my life. I still remember the taste of Sharon Fruit. It was delicious.. Yummy !!! Please check out my Facebook Sharon Fruit page if you are also interested !!    Click here to view my FB page. Feel free to hit the like button