Copy Facebook Contacts to LinkedIn - Easy! 2 Minutes

So, Facebook makes it impossible to export your contacts, right? Well, yes and no.

Using a simple workaround, you'll be sending a LinkedIn invite to all your Facebook Friends. Follow these simple steps, even check out the Youtube video I made for ya below:

1. Sign in to your facebook account and in another tab sign in to Yahoo! account.
1. If you don't have a yahoo account, get one. It's FREE.
2. While on Yahoo mail (located at mail.yahoo.com), click on "Contacts".
3. Click "Import Contacts" or some such thing, then "Import from Facebook"
4. Click yes or OK or Next and let Yahoo have your FB contacts.
5. Now go to your LinkedIn account and sign in.
6. Go to the little import man with the plus sign in the upper right hand corner and click the Yahoo button

1. 
   
7. Let it Invite them and you're done!

Check out my video below for an Audio-Visual tool to help you!

How to Use the CELLS() Object in Excel VBA

When you're coding in Excel VBA, you will use the CELLS() object all the time. Why? Because it allow you flexibility. You can have a Dynamic - ever changing row or column and use the same variable.

Here's how it works:
You type "Cells" and put a parentheses. Put the row number you want, a comma, then the column number, end parenthesis. Simple.

Before this sounds too complicated, let's just try it.

1. Open Excel and hit Alt + F11. This opens Visual Basic Editor.
2. Make a new Module by clicking the dropdown as pictured below:

2. Copy and paste this code:
Sub MyCellsMacro()

Cells(1,1) = 100

End Sub


To run this macro, just click within the area of the macro and hit F5.
You'll see that it put the number 100 in cell A1 just as if you'd typed it there.

Watch the Video!!
If you want cell F2, then you need to think in terms of row 2, column F or number 6.
Type Cells(2,6) = "hello" and run that! It will put the word hello in cell F2.

ALTERNATE METHOD:
You may also type in the column letter surrounded by quotes. Example:
Cells(2,"F") = "hello"

TO RUN YOUR NEW MACRO:
Just hit Alt+F8 and select your new macro, called MyFirstMacro, and double click or hit 'Run'.

Check out My Youtube Excel VBA Course - FREE.
www.youtube.com/user/ExcelVbaIsFun

Excel VBA Tutorial - Writing Your First Macro

For Excel users to maximize their performance, especially Excel's power users, they need to understand how to utilize Excel's built in VBA or Visual Basic for Applications.

It's very easy to get hooked once you've created a report or a macro that saves you countless time!

In this post, we'll make a simple macro to make the Cell A1 to have the value of 100 in it. It's very easy.

Follow these easy steps:

1. Get the Developer tab. In Excel 2010 and 2007, just go to Excel Options from the File or Orb and click the checkbox for Developer in the Ribbon options.

2. Hold Alt and press F11 to get in the Visual Basic Editor.

3. In the text area type the following:

Sub MyFirstMacro()

Range("a1") = 100

End Sub


That's it! You wrote your first macro!!!

Ok the Breakdown. . .

When you type Sub and hit spacebar and type a name for your macro, Excel knows you're making a new procedure (aka macro).

Everything in between that and the "End Sub" is your code. Then, we simply told it that cell A1 needs to be 100.

TO RUN YOUR NEW MACRO:
Just hit Alt+F8 and select your new macro, called MyFirstMacro, and double click or hit 'Run'.

Check out My Youtube Excel VBA Course - FREE.
www.youtube.com/user/ExcelVbaIsFun