Code for Control + Shift + "

[Boost]

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

 

[Boost]

Thanks, Rick. That works perfectly!

 

[My Aswer Is This]

Glad to see you have things working. Any time you have questions about a script you would get quicker help by showing us your script. Glad we were able to help you. Come back here to Mr. Excel next time you need additional assistance.

Thanks, Rick. That works perfectly!

 

[Boost]

Thank you both. That worked out much better. I will make sure to add the code next time.

 

[My Aswer Is This]

That's great

Thank you both. That worked out much better. I will make sure to add the code next time.