$$Excel-Macros$$ keep one column constant while changes the second

I am trying to run a simple script the calculates the correlation between column B and the column C, then does the same thing for column B and column D, and then column B and column E, etc.I can't figure out how to keep the first column (i.e. column B) constant, while moving reference to the se

$$Excel-Macros$$ VBA and macro for importing data into separate worksheets with appropriate titles

code is shown below: Sub ImportMembers() ' ' ImportMembers Macro ' Macro recorded 9/20/2010 by Fred Blair ' Dim oSheet As Worksheet, vRet As Variant Set oSh

$$Excel-Macros$$ wrong number of argument

Hi All, I'm new to Excel macro and I've have two problems: 1. A macro that used to work fine is now giving me an error stating: Wrong number of argument or invalid property assignment. Any ideas what I did wrong? The code is: columns("C:C").Select Selection.Insert Shift:=xlToRight, CopyOrigi