Excel: Code for Control + Shift + "

Hi Everyone, Anyone have any idea how to code a shortcut: Control Shift Apostrophe (Control+Shift+")? I am trying to copy the last cell in a column to the cell below it at the end of a long macro. It is working and making all the sheets, but I need to add one line using the contents of the final line cells above when the totals are printed. The number of rows will vary every month so it needs to deal with the last line. The keyboard shortcut works great so it would be helpful to know how to code it. Thanks

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of November 28, 2016.

For more resources for Microsoft Excel