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
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
Last edited: