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:35
This 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 self-reference an Excel cell.
To reference the entire column to the left in a worksheet function:
Since this is a programming question site, I assume you mean in VBA.
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:
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).