Search results for query: *

Hello All, What is the excel vbe code to move the cell pointer to the top left (home) of a frozen pane? I need the same effect as ctrl-home would have without the cell reference as the location of the frozen pane will change constantly. Hope this is clear. Thanks a lot for your help

In my macro I'd like to put a sum formula at the end of the column, but within the column there are blank cells and since the spreadsheet has constantly # of rows there is no static range I can input in the macro to capture all of my data. Is there a macro command to use to capture an...