tag:blogger.com,1999:blog-82925956646254969552024-02-02T08:42:32.630+05:30Active ServicesArjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.comBlogger105125tag:blogger.com,1999:blog-8292595664625496955.post-66611134860678433852015-11-22T19:31:00.000+05:302015-11-22T19:31:00.156+05:30To find EMPTY ROW in excel using macro VBA
Method 1:
In this method CountA function is used
Syntax:
WorksheetFunction.CountA(Range("ColumnRange")) + 1
Example:
MsgBox WorksheetFunction.CountA(Range("A:A")) + 1
Method 2:
In this method xlUp is used
Syntax:
Range("A" & Rows.Count).End(xlUp).Row
Example:
MsgBox Range("A" & Rows.Count).End(xlUp).Row
Method 3:
In this method Cells Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-90732065485952664572015-04-14T21:21:00.001+05:302015-09-20T18:01:49.508+05:30SAVE THE INTERNET!! SAVE THE INTERNET!!
What is net neutrality?
Internet is built around the idea of openness. It allows people to connect and exchange information freely, if the information or service is not illegal. Much of this is because of the idea of net neutrality. If you like the current state of the internet, you should know about net neutrality. Many web users are aware of it. But if you are not, don't worry. We explain itArjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-41298329037138375942015-04-02T15:22:00.002+05:302015-09-20T18:01:49.348+05:30Latest tricks to buy Yureka Yu on Amazon.in
Click image to ZOOM
Follow The instructions Carefully:
Copy Below line.
setInterval(function(){ jQuery('.btn').trigger('click'); console.log('Active services by arjun Trying to add Yureka to your cart, dont press any key'); },10);
Open Amazon Yureka Page click here.
Now press F12 Button and select Console And past that copied code and press enter like below image
Click Image to Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-84679837405968673102014-04-23T15:04:00.000+05:302015-09-20T18:01:49.485+05:30Cisco Packet Tracer 6.0.1 for Windows
About CISCO Packet Tracer
It is a powerful network simulation software which allows student to experiment with network designs and behaviour.
It supports number of Application Layer protocols.
It also supports basic routing Protocols like RIP, OSPF, and EIGRP etc..
It is a learning aid for Cisco routers and switches.
Packet Tracer 6.0 - NewArjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-16052818055686890232014-04-14T10:28:00.000+05:302015-11-13T18:29:12.281+05:30Uninstall Bluestacks
Open Run(WINDOWS KEY+R) and type appwiz.cpl and click OK.
find Bluestacks and uninstall it. then
Restart your machine
Open -> run -> type temp and click ok.
select all files and folder and delete it and skip file which give delete error.
Open -> run -> type %temp% and click ok.
select all files and folder and delete it and skip file which give delete error.
Goto C:\Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-88105087799599855672014-04-14T10:22:00.000+05:302015-09-20T18:01:49.490+05:30Sharing files to bluestacks from your computer
Copy the required files to following folder:
In Windows 7/8/8.1
C:\Program Data\BlueStacks\UserData\SharedFolder
In Windows XP
C:\Documents and Settings\All Users\Application Data\BlueStacks\UserData\SharedFolder
(If you cant find above location then just copy the address and paste on computer address bar)
Download and install ES file Explorer app in Bluestacks.
NowArjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-62958629501858384002014-04-14T10:10:00.000+05:302015-09-20T18:01:49.430+05:30Install Bluestacks on 1GB RAM machine
Download Orca installer Editor and Bluestacks Offline Installer .
Install Orca by double on orca.mis package.
Go on Bluestacks download folder
Right click on it.
Select edit with orca.
Select LaunchCondition in left panel in opend window
delete the row Installed OR PhysicalMemory>= 1024
Now select InstallExecuteSequence form the left panel
Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com1tag:blogger.com,1999:blog-8292595664625496955.post-9179317179306912042014-04-14T09:58:00.000+05:302015-09-20T18:01:49.514+05:30Backup your apps and data using Go backup pro
Download Go backup pro and install it.
Backup your required app+data using Go Backup pro and it will saved in SDCard>GoBackup
Then copy that folder into BstShared folder in SDCard using ES file Explorer App.
Explorer BstShared Folder in Computer by following steps.
IN Windows 7/8/8.1 :-
C:\Program Data\BlueStacks\UserData\SharedFolder
IN Windows XP :-
C:\Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-33536596060085123082014-04-02T22:02:00.000+05:302015-09-20T18:01:49.319+05:30Windows Phone 8.1 show Virtual Assistant CORTANA
CORTANA is a virtal assistant developed by Microsoft and introduce in Windows Phone 8.1
Some features are:-
Cortana responds to natural language commands.
It helps to scheduled reminders.
It is similar to SIRI and GOOGLE NOW.
Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-49239845083557916252014-02-18T20:33:00.001+05:302015-09-20T18:01:49.391+05:30Universal Bluestacks Rooting Software
Installing/Rooting Procedure
Download Bluestacks RootEZ 32 bit-64 bit.
Extract files by using winrar (32 bit, 64bit) or 7zip(32 bit, 64bit).
Open the extracted folder ,
For XP users
Double Click on Bluestacks RootEZ.exe.
For Vista and above users
Right click on file Bluestacks RootEZ.exe and select Run as administrator.
Then Click Automatic Detect Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com8tag:blogger.com,1999:blog-8292595664625496955.post-5281145692142591902014-02-18T19:36:00.000+05:302015-09-20T18:01:49.408+05:30BlueStacks App Player's
Latest Version of BlueStacks
BlueStacks for Low Graphics Computers
BlueStacks App Player Installing Procedure
Universal BlueStacks Rooting Software And
Installing Procedure
Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com3tag:blogger.com,1999:blog-8292595664625496955.post-89811873671026317752013-12-20T22:13:00.000+05:302015-09-20T18:01:49.501+05:30Free VPN For Unlimited Surfing and Downloading
USA FREE PPTP VPN List
PPTP VPN Server IP Username Password
================================================
67.212.188.13 freevpn accounts
206.190.129.237 websitevpn.com freevpn
67.212.188.11 mybestvpn Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com1tag:blogger.com,1999:blog-8292595664625496955.post-12936316141087267752013-09-16T13:40:00.001+05:302015-09-20T18:01:49.247+05:30Online free Linux Terminals
Online free Linux Terminals
Linux Terminal 1
Linux terminal 2
Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-8123610956575368352013-09-05T12:20:00.000+05:302015-09-20T18:01:49.473+05:30Setup Apache Tomcat Server to RUN JSP program.Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-8845556700218466922013-07-26T13:42:00.000+05:302015-09-20T18:01:49.496+05:30What happen of Data in Cloud if it is Raining??Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-25881362417115383782013-07-16T13:46:00.000+05:302015-09-20T18:01:49.300+05:30Ubuntu 13.04 (Raring Ringtail) Review
Fast, free and raring to go
The stable is refined and feels more optimized.
13.04 is in the middle of the LTS cycle, with 14.04.
Reduced memory consumption.
A great Number of UI Fix like icon and graphic change.
This single version of os will work in Mobiles and tablets.
Easy Download Options on videos.
Download Desktop Version:
PC (Intel x86)Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-64843508668043415662013-04-08T10:51:00.000+05:302015-09-20T18:01:49.442+05:30Write a c++ program to read a text file and count number of vowels.
#include<fstream.h>
#include<iostream.h>
#include<ctype.h>
#include<conio.h>
void main()
{
char fname[30],lname[30];
int c=0;
char ch;
clrscr();
cout<<"Enter First Name = ";
cin>>fname;
cout<<"Enter Last Name = ";
cin>>lname;
ofstream ostud("stud.asa", ios::out);
ostud<&Arjun Singhhttp://www.blogger.com/profile/11404469892254623869noreply@blogger.com2tag:blogger.com,1999:blog-8292595664625496955.post-33763149905811985512012-07-04T12:30:00.002+05:302015-09-20T18:01:49.324+05:30Create a class Distance containing Feet and Inches as data members. Write a C++ program to read distance from user, store it in the file and to read it from the file and display it to the user. Use operator overloading for the following: 1. << to write distance object in inches format to a file 2. >> to read inches from File.
#include<iostream.h>
#include<fstream.h>
#include<conio.h>
class Distance
{
int feet;
int inches;
public:
friend istream& operator>>(istream &in,Distance &d);
friend ostream& operator<<(ostream &out,Distance &d);
};//End of class
fstream file;
istream& operator>>(istream &in,Distance &Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-8292595664625496955.post-37664556233558648992012-07-04T12:30:00.001+05:302015-09-20T18:01:49.342+05:30Write a menu driven C++ program using class to calculate Area and Volume of rectangle using inline function.
#include<iostream.h>
#include<conio.h>
class Rectangle
{
int l;
int b;
public:
void getval()
{
cout<<endl<<"Enter length and breadth of rectangle: ";
cin>>l>>b;
}
inline int area()
{
return(l*b);
}
inline int volume(int h=10)
{
&Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-16983616522727094802012-07-04T12:30:00.000+05:302015-09-20T18:01:49.269+05:30Create a class MyFile containing: - FILE *fp; - Char fn[maxsize]; Write necessary member Functions using operator overloading: 1. + F3=F1+F2 Put contents of F1 and F2 in F3. 2. - -F3 Changes the case of all upper and lower case characters in F3.
#include<iostream.h>
#include<fstream.h>
#include<string.h>
#include<conio.h>
#include<ctype.h>
class MyFile
{
fstream fp;
char *fn;
public:
void getfilename(char str[])
{
int l=strlen(str);
fn=new char[l+1];
strcpy(fn,str);
}
//-----------------------------------------------------
void operator+(MyFile &Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-8292595664625496955.post-26232084477057218622012-07-03T12:30:00.002+05:302015-09-20T18:01:49.306+05:30Consider the following Class mystring { char str [100]; Public: // methods }; Overload operator “!” to reverse the case of each alphabet in the string.
#include<iostream.h>
#include<string.h>
#include<ctype.h>
#include<conio.h>
class mystring
{
char str[100];
public:
void getstring()
{
cout<<endl<<"Enter string: ";
cin>>str;
}
void operator!()
{
int l=strlen(str);
for(int i=0;i<l;i++)
{
if(isalpha(str[i]))
{
if(islower(str[i])Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-20504177671289411882012-07-03T12:30:00.001+05:302015-09-20T18:01:49.284+05:30Create a class currency containing rupees and paise as data members. Write necessary member functions using operator overloading for the following: 1. currency (long int rup=0,int paise=0) 2. currency & operator += (currency &) (to add one currency to another) 3. currency & operator - = (currency &) (to subtract one currency from another) Accept Rupee & paise from user and display it.
#include<iostream.h>
#include<conio.h>
class currency
{
long int rup;
int paise;
public:
void getcurrency()
{
cout<<endl<<"Enter currency in rupees and paise: ";
cin>>rup>>paise;
}
currency operator+(currency &c)
{
currency temp;
temp.rup=rupUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-9369740103998471302012-07-03T12:30:00.000+05:302015-09-20T18:01:49.526+05:30Create a C++ class for a student object with the following attributes—roll no, name, number of subjects , marks of subjects. The number of subjects varies for each student. Write a parameterized constructor which initializes roll number, name and number of subject and creates the array for marks dynamically, write member function for accepting marks and display all information of student.
#include<iostream.h>
#include<string.h>
#include<conio.h>
class student
{
int rollno;
char name[20];
int no_of_sub;
int *m;
public:
student() {}
student(int r,char n[],int nos)
{
rollno=r;
strcpy(name,n);
no_of_sub=nos;
accept();
}
void accept()
{Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-48573911184113410792012-07-03T00:29:00.000+05:302015-09-20T18:01:49.386+05:30Write a C++ program to find area of triangle, circle, and rectangle using function overloading.
#include<iostream.h>
#include<conio.h>
void area(int r)
{
cout<<endl<<"Area of circle="<<3.142*r*r;
}
void area(int b,int h)
{
cout<<endl<<"Area of triangle="<<0.5*b*h;
}
void area(float l,float b)
{
cout<<endl<<"Area of rectangle="<<l*b;
}
int main()
{
int r,b,h;
float l,br;
clrscr()Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8292595664625496955.post-74684004063776489372012-07-02T12:30:00.001+05:302015-09-20T18:01:49.462+05:30Consider a class point containing x and y coordinates. Write necessary functions for the following cases: 1. to accept a point 2. to display it 3. to find distance between two points using operator overloading (-) (Use friend function)
#include<iostream.h>
#include<conio.h>
class point
{
int x;
int y;
public:
void accept()
{
cout<<endl<<"Enter x,y co-ordinates of point: ";
cin>>x>>y;
}
void display()
{
cout<<endl<<"X:"<<x<<" Y:"<<y;
}
friendUnknownnoreply@blogger.com0