In excel, if I want to perform a function with the column to the left, how do I go about this?
migrated from stackoverflow.com Nov 2 '10 at 11:35This question came from our site for professional and enthusiast programmers. 


Here's how to reference the cell in the column to the left in a worksheet function:
there are probably other ways to do it, but I haven't found a good, terse way to selfreference an Excel cell. To reference the entire column to the left in a worksheet function:



If you are in cell H1, and you want to sum column G, type =SUM(G:G). 


Since this is a programming question site, I assume you mean in VBA. The Simply subtract one and use it (assuming it's not 1 already, of course). If you want the actual column letter (you don't need it for calculations but may want it anyway), use:
along with:
If this isn't a VBA question, it doesn't really belong here (although I see by one of your comments that you're talking about running a function, so I guess you did mean in VBA after all). 

